Dewald Botha
open source web thoughts
open source web thoughts
Apr 8th
To dump data in MySQL command line is one of the easiest things to do. All you have to do is follow these 3 easy steps in your linux command line:
1. Dump the schema only. This will not contain any data, procedures or triggers, but only create info. This will allow you to easily import your original schema later on.
mysqldump -uroot -proot -d --skip-triggers myDatabase > myDatabase_schema.sql
The -u specifies your username, and must be followed by your username e.g. -uroot. This is the same with your password, -proot.
The -d tells mysqldump to not dump any data in the schema and the More >