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 moreHow to increase MySQL performance when loading a Dump File
In MYSQL, as well as most database engines, restoring a backup, or importing from an existing dump file can take a long time depending on the number of indexes and…
Read moreMySQL – DateTime vs. TimeStamp – When to use?
This question often comes up, and while there is often a heated debate, these are my thoughts on the subject. I typically use a timestamp when I need to record…
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