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)
- Flood Apache Benchmarking tutorial – How to do website performance analysis and tuning with flood and Apache 2
- A funny caricature representing our human ways
- Virtualbox Shared folder set up on Linux between Host and Guest OS – Set up Virtualbox shared folder to Copy files from PC Host to Guest
- How to monitor Postfix Mail server work correct with simple one liner Zabbix user parameter script / Simple way to capture and report SMTP machine issues Zabbix template
- Free Software in Balkans 2010 (A free software conference on the Balkanies is approaching)
- Installing newest Nessus Security Scanner on Debian Testing/Unstable (Squeeze/Sid) Linux
- How to add multi-lingual (multi language) support in Joomla 1.5
- Testing Qmail installation for problems: Common reasons for unworking qmail / How to debug Qmail mail server failing to delivery or send emails
- Two successfully taken exams
- How to set up a proper mail server SPF TXT record in Bind (named) DNS server
- Sofia Bulgaria one of the Most Ancient cities in Central Europe – the History of Europe
![Download PDF](https://www.pc-freak.net/blog/wp-content/plugins/wp-post-to-pdf/asset/images/pdf.png)
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.