Import a MySQL dumpfile into my database
After you have dumped out your data into a file as described here, FTP or scp that dump file to the home directory (/) on our system.
Once you have uploaded the dump file to your account here, get a shell prompt on our system using telnet or ssh.
Now import the dump file into MySQL by typing all the following on 1 single line at the shell prompt:
mysql -p -h DBSERVER dbname < dbname.sql
The above assumes that your database name on our system is “dbname” and the dumpfile that you uploaded was named “dbname.sql“. Replace those with your correct database name and dumpfile filename. Also replace DBSERVER with your correct database server name.
Related Posts
