| topvip |
2013-04-01 10:09 PM |
How to import a big database when phpmyadmin can't?
if you have SSH access then you can use the following commands to backup / restore databases
Quote:
mysql -u[Username] -p[Password] [Database Name] < filename.sql - Dump a SQL file into a MySQL database. Note the "<".
Replace "[Username]" with the database username (generally controlpaneluser_databaseuser). Replace "[Password]" with the database password and replace "[Database Name]" with the database name. Finally change "filename.sql" to the correct filename/location.
|
eq.. to be done from the folder where you want the file to be saved
Quote:
mysql -umyusername -pmypassword mydatabasename < myfilename.sql
|
Quote:
mysql -u[Username] -p[Password] [Database Name] > filename.sql - Dump a MySQL database to a SQL file. Note the ">".
Replace "[Username]" with the database username (generally controlpaneluser_databaseuser). Replace "[Password]" with the database password and replace "[Database Name]" with the database name. Finally change "filename.sql" to the correct filename/location.
|
eg.. to be done from the folder where the sql file is
Quote:
mysql -umyusername -pmypassword mydatabasename > myfilename.sql
|
|
