I have created database named employee database and i want to import MySQL dumpfile into my employee database? what are the syntax used while importing file. Any recommendations and suggestions are appreciated.
I have created database named employee database and i want to import MySQL dumpfile into my employee database? what are the syntax used while importing file. Any recommendations and suggestions are appreciated.
Import the dump file into MySQL by typing all the following on 1 single line at the shell prompt: mysql -p -h DBSERVER dbname < employee.sql The above assumes that your database name on our system is "dbname" and the dumpfile that you uploaded was named "employee.sql".
You can easily restore or import MySQL data with mysql command itself. The easiest way is to split the original sql file into manageable blocks... a separate file for each table maybe since your data base is so large. You can do this manually from the file that you already have... or export the original sql in blocks as separate files.
Using the phpMyAdmin authoring tool you can easily import/add an existing database to your current database. If the .sql file that you are attempting to import is too large, the import via phpMyAdmin may timeout in your browser. An alternative way to import your .sql file is to run the import command via a SSH session. The only restriction is that this file has to be of either .SQL or .PHP type. If your database file is of a different type, you will need first to convert it before importing to phpMyAdmin.
Bookmarks