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)
- Configure rsyslog buffering on Linux to avoid message lost to Central Logging server
- Kill everything that Moves (KETM) an arcade spaceship Tyrian GNU / Linux game
- Install simscan on Qmail for better Mail server performance and get around unexisting suid perl in newer Linux Debian / Ubuntu servers
- How a Ponzi Scheme works – Ponzi the most famous fraudulent network
- How to install custom Font files on Linux with font-viewer, fc-cache, font-manager – Install Church Slavonic fonts on GNU / Linux
- Zabbix script to track arp address cache loss (arp incomplete) from Linux server to gateway IP
- Bulgaria Top outsource destination – 5th in the World and 2nd in Europe in list of best countries to outsource business to
- Disable NetworkManager automatic Ethernet Interface Management on Redhat Linux , CentOS 6 / 7 / 8
- Botevo’s Forest
- Sjecas li se dolly bell? – Do you remember Dolly Bell? – A classic serbian movie by Emil Kosturica
- Preeminent Saint apostles Peter and Paul feast in the Holy Eastern Orthodox Church – June 29
![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.