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)
- Sick
- Fixing insserv: warning: script ‘…’ missing LSB tags and overrides on Debian and Ubuntu Linux
- How to fix problems with encoding not showing umlauts in after import of sql data to MySQL
- The Holy Martyrs of Novo Selo Monastery “Holy Trinity” Selo Bulgaria. The holy priest-martyrs and martyrs who suffered by the Turks on May 9, 1876, canonized on April 3, 2011
- Hot wo install geoip and mod-geip2 to Apache in CentOS 5.5 Linux
- How to convert FLV to AVI and AVI to FLV Videos on Linux and BSD with avidemux and ffmpeg – Simple video editting with LiVES
- IE PassView – View stored Microsoft Internet Explorer passwords program
- Install Microsoft .NET 2.0 & 3.0 (Dotnet) on WINE Windows Emulator on GNU / Linux
- Linux: Delete empty lines from text file with sed, awk, grep and vim
- A Pilgrim journey to Obrotishte, The Tekke in Obrotishte (The beginning of the Orthodox Lent)
- Convert png files to ico on Linux – Create “icon” files from pictures
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.