HubsInfo Network
Social PHP Linux Material Design Web Hosting Online Games SimCity BuildIt

Import large mysql databases through command line

0 Members and 1 Guest are viewing this topic.

Import large mysql databases through command line
« on: January 06, 2016, 03:49:14 PM »
Windows XP, Vista, 7, 8, 10
Open your Command Prompt:
Press Windows/Start button > Search programs and files > type cmd

Connect to your mysql database:
Code: [Select]
cd C:\Program Files\MySQL\MySQL Server 5.7\bin
Code: [Select]
mysql -u root -p
Select your database:
Code: [Select]
use yourdbname[/SIZE]
Import command:
Code: [Select]
source C:\Program Files\MySQL\MySQL Server 5.7\bin\yourdbname.sql[/SIZE]


Useful MySQL commands:
"\c" - clear;
"exit" - Exist mysql console;
« Last Edit: January 06, 2016, 04:11:31 PM by hubsinfo »

 


Linux Ubuntu Guides Linux games - Lutris.net