MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.
Import sql file from mysql command line by using PuTTY emulator
By Using phpMyAdmin, The sql file import operations for bigger files are very difficult. There is a chance that it’ll timeout during the operations and also, browser will be using heavy memory. So how to get rid of these issues?
No problems! Just try importing the sql file directly in mysql console (command line). I’m explaining the steps based on a web hosting context. (For eg. You’ve a hosting account (Shared or Dedicated) with GoDaddy, Bluehost, Hostgator etc)
- Login into your server using PuTTY
- login into mysql console
mysql -uUsername -hHostname -pPassword
(This is the command for directly logging into the mysql server. Please note that there is no space after -u, -h, -p. Also Replace Username, Hostname & Password with your DB details)
- Choose your database for import operation
Replace DBname with your own database name
- Import operation
The import operation initiates once you execute the above command. We used source command to specify the location of your sql file (You’ve to give correct path of the sql file). That’s it.