MySQL – A simple script to truncate all MySQL tables in a Database
Want a quick and dirty way to Truncate all the tables in a MySQL DB? You can use the following one line script. mysqldump -ppassword YourDBName –no-data dumpfile | mysql…
Read moreMySQL – Best way to remove all data from a table
There are multiple ways in which to remove all data from a MySQL Table. The first is to use the DROP TABLE command, which will remove the entire table with…
Read moreMySQL – Restoring from a Dump Syntax
Here’s how to pass the arguments to MySQL to restore from a Dump: mysql [database name] < [backup file name] The “[database name]” specifies the name of the database to…
Read more