Import .csv file
⇛ Step 1: Copy your desired importing file into the mysql using following steps:
Open the wamp installed folder (lets consider it as a D:\ drive)
D:\wamp\bin\mysql\mysql5.5.20\bin
Paste your database file there (in bin folder)
Right click on (Start->All Programs->Accessories->Command Prompt) Command Prompt and click on ''Run as administrator''
Execute the following command:
D:\wamp\bin\mysql\mysql5.5.20\bin
mysql -p -uusername
Example: mysql -p -uroot
Press ''ENTER'', then it will prompt you to enter the password. Provide the appropriate password to it, then it will go in mysql mode like this:
mysql>
⇛ Step 2: Select your database name using command
use [database name]
Example: use mydatabase
⇛ Step 3: Here is the following command for importing .csv file (''Make sure that you copied your desired files into bin folder'')
load data local infile 'filename.csv' into table tablename fields terminated by 'terminate character' enclosed by 'enclosed character' lines terminated by 'terminate character'(col1,col2,@ignore, col4);
Example:
load data local infile 'user.csv' into table user fields terminated by '|' enclosed by ' ” '
lines terminated by '\n' (id,username,@ignore, password);
''@ignore'' specifies the extra column in the csv which you don't want to import into the table.
Import .sql file
⇛ Step 1: Use ''same'' step 1 as Import.csv file section
⇛ Step 2: After that for importing .sql from command line you need to use following command
mysql -uusername -p databasename < filename.sql
Example'': mysql -uroot -p mydatabase < user.sql
Export database to the .sql file
⇛ Step 1: Open the command prompt ('''Run as administrator''') and execute following command:
D:\wamp\bin\mysql\mysql5.5.20\bin>
⇛ Step 2: For exporting database from command line you need to use following command
mysqldump -uusername -p databasename > filename.sql
Example: mysqldump -uroot -p mydatabase > mynewdb.sql
Export table to the .sql file
⇛ Step 1: Open the command prompt (''Run as administrator'') and execute following command:
D:\wamp\bin\mysql\mysql5.5.20\bin>
⇛ Step 2: For exporting table from command line you need to use following command
mysqldump -uusername -p databasename tablename > filename.sql
Example: mysqldump -uroot -p mydatabase mytable > newtable.sql
Export Multiple tables to the .sql file
mysqldump -u username -p databasename table1 [table2 ...]> path/to/dump.sql
Example: mysqldump -uroot -p mydatabase tb1 tb2 tb3 > tbsdetails.sql
