How do I import a MySQL database?
You create your database first (will be created within 15 minutes) from your web control panel and then import from your dump file. Log onto your shell account and enter the following at the command line mysql -u username -p database_name < /path/to/dumpfile Example: You create the database 'foon' and your dump file is /home/userid33/mydata.dump The command you are typing at the prompt of your shell account would be: mysql -u userid33 -p foon < /home/userid33/mydata.dump Hit Enter, you will be prompted for your mysql database password Enter password: enter_your_mysql_password_here Hit Enter! your are done!
Related Questions
- Managing your MySQL Database Systems ยป Foreign Keys/relationships: How can SQLyog handle import of DUMPs with tables using Foreign Keys with HTTP tunnel?
- When I try to IMPORT the SIMHL-Database.sql into my MySQL database, I get an error?
- How can I import data from an existent MySql / SQL Server online database?
