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)
- New Russian Saint canonized in Bulgaria Archibishop Seraphim (Sobolev) a true defender of true Christ given faith, the Holy Eastern Orthodox Church
- How to set up dsmc client Tivoli ( TSM ) release version and process check monitoring with Zabbix
- Trip to Geographical Center of Europe Polotsk Belarus
- How to remove parameters from URL on Apache (Reverse Proxy) with .htaccess and mod_rewrite – Remove query string from Link
- How to modify domain in WHM Accelerated administrator and how to fix “Unable to change domain name”
- The Feast of the Holy Great Sovereigns St. Constantine and Helen of Constantinople in the Bulgarian Orthodox Church
- 19 October Saint John of Rila Тhe Wonderworker – A little known Hermit saint of Great importance and fervent prayer intercessor for humanity
- How to install Linux or *BSD to USB flash drive (memory stick) using Debian GNU / Linux
- Virtual Keyboard for Linux and other Freedom respecting operating Systems
- How to set a crontab to execute commands on a seconds time interval on GNU / Linux and FreeBSD
- How to reboot remotely Linux server if reboot, shutdown and init commands are not working (/sbin/reboot: Input/output error) – Reboot Linux in emergency using MagicSysRQ kernel sysctl variable
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.