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)
- 19 October – Saint John of Rila (The Greatest venerated Bulgarian saint) Dormition feast day
- How to track server disk activity on Linux with iostat
- Install xmame from source on Debian Linux 7.0 (Wheezy) to play for better MAME (Arcade Games Emulation)
- A Black and White Story and To Download an Apple a nice artistic videos produced by a friend
- Thanks to God I’m in Arnhem the Netherlands! 🙂
- Websites I view per daily basis
- How to Screenshot single Windows on GNU / Linux GNOME Desktop
- Fix to “413 Request Entity Too Large” error in Nginx webserver and what causes it
- Delete empty files and directories under directory tree in Linux / UNIX / BSD
- Orthodox Christian Church songs performance of Psalms 1, 2, 3
- Make Icedove a.k.a. Thunderbird have a Gnome look
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.
