Categories
If you have a large mysql database file, the better way for big SQL files is to import via SSH command.
1.) Upload the SQL file via FTP Software on your webspace in for example your public_html folder (but do not forget to delete the SQL file (test.sql) after importing)
2.) Open SSH client and login as root
3.) Run the following command (don’t forget to change the path and user and database information):
mysql -u databaseuser -p databasename < /home/username/public_html/test.sql
You will get:
“Enter password:” Enter database password.
Maybe it will take a while to import the 200 MB database (depending on server configuration).
Good luck!
Originally posted on May 24, 2023 @ 4:01 pm
