How to export and import the databases in MySql.

2
votes

phpMyAdmin shows an error during importing the exported .sql file. It gives message like this SQL query:

--

-- Database: mcadatabase

--

-- Table structure for table trick

CREATE TABLE IF NOT EXISTS trick ( id int(5) unsigned NOT NULL, question varchar(20000) NOT NULL, option1 varchar(200) NOT NULL, option2 varchar(200) NOT NULL, option3 varchar(200) NOT NULL, option4Right varchar(200) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; MySQL said: Documentation

1046 - No database selected

6
mysqlxampp

6 Answers

2
votes

With phpMyAdmin, you need to create a database named mcadatabase. Then, select this database and select Import.

2
votes

Use command Line to import/export database

Import:

  • C:\Program Files\MySQL\bin\mysql -u username -p databasename < file_name.sql

Export:

  • C:\Program Files\MySQL\bin\mysqldump -u username -p databasename > file_name.sql
1
votes

For Exporting open a terminal :-

mysql -u root -p your_database_name > any_file_name.sql

For Importing:-

mysql -u root -p < sql_file_name.sql

For exporting only a table in your database:-

 mysql -u root -p your_database_name your_table_name > any_file_name.sql

Importing a table remains same as above.

Hope this helps!

0
votes
mysqldump -u USER -pPASSWORD DATABASE > /path/to/file/dump.sql
0
votes

Export

mysqldump -u username –-password=your_password database_name > file.sql

Import

mysql -u username –-password=your_password database_name < file.sql