Wednesday, 19 October 2016

My SQL command to create SQL Dump

mysqldump command is used to create a text version of the database. This creates a SQL file that contains all SQL statements  which we can use to restore/recreate the original database.

Below is the command:

$ mysqldump -u [uname] -p[pass] [dbname] > [backupfile.sql]


0 comments:

Post a Comment

Note: only a member of this blog may post a comment.