How do I import a MySQL .SQL text file to MySQL database sever using command line or gui tools?
You can import a MySQL script (or .sql) file into MySQL server using
- Unix / Linux shell prompt.
- phpMyAdmin web based gui tool.
Unix / Linux shell prompt example
Copy a .sql file to a remote server using sftp or scp client:
$ scp foo.sql vivek@serer1.cyberciti.biz:~/
Login into a remote server using ssh client:
$ ssh vivek@server1.cyberciti.biz
Type the following command to import a .sql file:
mysql -u USERNAME -p -h localhost YOUR-DATA-BASE-NAME-HERE < YOUR-.SQL.FILE-NAME-HERE
In this example, import a 'foo.sql' file into 'bar' database using vivek as username:
mysql -u vivek -p -h localhost bar < foo.sql
phpMyAdmin
Login to phpMyAdmin. Open a web-browser and type phpMyAdmin url:
http://server1.cyberciti.biz/phpmyadmin/
In phpMyAdmin, choose the database you intend to work with from the database menu list (located on the left side).
Fig.01: phpMyAdmin Database Selection
Choose the IMPORT tab > Click on Browse your computer "Choose file" > Select file > Choose Ok > Choose Go
Fig.02: phpMyAdmin Importing .SQL File
You should follow me on twitter here or grab rss feed to keep track of new changes.
Featured Articles:
- 30 Handy Bash Shell Aliases For Linux / Unix / Mac OS X
- Top 30 Nmap Command Examples For Sys/Network Admins
- 25 PHP Security Best Practices For Sys Admins
- 20 Linux System Monitoring Tools Every SysAdmin Should Know
- 20 Linux Server Hardening Security Tips
- Linux: 20 Iptables Examples For New SysAdmins
- Top 20 OpenSSH Server Best Security Practices
- Top 20 Nginx WebServer Best Security Practices
- 20 Examples: Make Sure Unix / Linux Configuration Files Are Free From Syntax Errors
- 15 Greatest Open Source Terminal Applications Of 2012
- My 10 UNIX Command Line Mistakes
- Top 10 Open Source Web-Based Project Management Software
- Top 5 Email Client For Linux, Mac OS X, and Windows Users
- The Novice Guide To Buying A Linux Laptop
![Linux Copy File Command [ cp Command Examples ]](http://s13.cyberciti.org/images/shared/rp/3/7.jpg)
{ 3 comments… read them below or add one }
If you have a big database file. I recommend use always command line. Other solution zip your .sql file and improve your php.ini settings (Upload Max file Size, Max execution time,post max size, memory). Don’t forguet check the collation for your database. I suggest always use innodb and uft8_unicode_ci
nice. thanx for the info. Additional info: Importing from PMA is limited in file size. nor with the shell
nice tutorial thanx for the great info. you saved my time.