Create and import database from url

Question

I've script in directadmin which create new clean database:

#Create DB
  /usr/bin/mysqladmin -uda_admin -p$(cat /usr/local/directadmin/conf/mysql.conf | grep pass | cut -d\= -f2 ) create ${wpconfigdbuser};
  echo "CREATE USER ${wpconfigdbuser} IDENTIFIED BY '${dbpass}';" | mysql -uda_admin -p$(cat /usr/local/directadmin/conf/mysql.conf | grep pass | cut -d\= -f2 );
  echo "GRANT ALL PRIVILEGES ON ${wpconfigdbuser}.* TO ${wpconfigdbuser} IDENTIFIED BY '${dbpass}';" | mysql -uda_admin -p$(cat /usr/local/directadmin/conf/mysql.conf | grep pass | cut -d\= -f2);

Now I need add to above code to import sample database from URL. example: mydomain.com/files/database.sql

Can anyone help me implement this to code?

update:

#Create DB
      /usr/bin/mysqladmin -uda_admin -p$(cat /usr/local/directadmin/conf/mysql.conf | grep pass | cut -d\= -f2 ) create ${wpconfigdbuser};
      echo "CREATE USER ${wpconfigdbuser} IDENTIFIED BY '${dbpass}';" | mysql -uda_admin -p$(cat /usr/local/directadmin/conf/mysql.conf | grep pass | cut -d\= -f2 );
      echo "GRANT ALL PRIVILEGES ON ${wpconfigdbuser}.* TO ${wpconfigdbuser} IDENTIFIED BY '${dbpass}';" | mysql -uda_admin -p$(cat /usr/local/directadmin/conf/mysql.conf | grep pass | cut -d\= -f2);

#Import DB:

    exec('mysql -u '.DB_USER.' -p'.DB_PASSWORD.' '.DB_NAME.' table_name < mydomain.com/files/database.sql;');

Now script create database and import sql file?

score 1 · Answer 1 · answered Jan 18 '22 at 12:47

1

Try this if you are using wordpress

exec('mysql -u '.DB_USER.' -p'.DB_PASSWORD.' '.DB_NAME.' table_name < mydomain.com/files/database.sql;');

It'll run a shell_exec using the constants defined in wp-config.php and execute the sql in the database.sql file.

Note this won't work in shared hosting

answered Jan 18 '22 at 12:47

Colin Gell

372
1
13

1

Thanks. I check this. I have dedicated server with DA. – Tom Arm Jan 18 '22 at 12:55
Could you please help us to implement to our code so that the above code is executed, i.e. database creation + import? Can you check my update? – Tom Arm Jan 18 '22 at 12:57
what does your .sql file look like i.e what statements are in it INSERT, CREATE etc – Colin Gell Jan 18 '22 at 13:10
this is example: https://github.com/vccw-team/repository-example-of-wp/blob/master/wordpress.sql – Tom Arm Jan 18 '22 at 13:32
that would create and insert the table and replace the existing table, with the above script. You might want to amend the .sql file so it only has the insert commands – Colin Gell Jan 18 '22 at 20:57
otherwise I'm not sure how to part execute that script? – Colin Gell Jan 18 '22 at 21:00

Create and import database from url

1 Answers1