I’ve recently had to dump a few tables from MySQL database to do so I used mysqldump,here is how:
/usr/bin/mysqldump database_name table_name -u root -p > table_name.sql
If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
Hey long time now see, thanks for dropping back again! 🙂
More helpful Articles
- How to extract database from a whole MySQL database dump with sed
- Installing the phpbb forum on Debian (Squeeze/Sid) Linux
- Few MySQL helpful commands in MySQL maintenance (MySQL rename Table, Empty MySQL Table Contents / Null Table records, Get info about variables in a Table, Change record in existing MySQL table, Get MySQL table privileges info, Some basic commands for MySQL issues debugging)
- How to install Skype on Nokia Communicator 9300 / 9300i (Download java Skype for Nokia 9300/9300i)
- Create Linux High Availability Load Balancer Cluster with Keepalived and Haproxy on Linux
- Zen Mozaik 2G and Debian Linux
- Installing a new server
- How to change / reset lost or forgot TightVNC administrator password
- Fixing picture non display in Windows Explorer Thumbnails preview
- How to properly control your Lenovo Thinkpad R61 fan rotation cycles on Linux with ThinkFan
- core dump after PHP5 and php5-extensions recompile (rebuild) from ports on FreeBSD – cause and solution
- Happy Sysadmin day! – Last Friday of July – The day of the system administrator
- NLP (neuro linguistic programming) lies and fallacies (a Sect building all around the world) sponsored probably by Scientology
- Linux: /var/log/wtmp – No such file or directory quick fix and why it might be missing on a server
Previoust Post: « How to cancel Godaddy domain privacy (retrieve domainsbyproxy.com account from Goddaddy)
Tags: database name
This entry was posted on Sunday, August 1st, 2010 at 3:04 pm and is filed under Linux, MySQL, System Administration. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.