I have a mysql database with 10 tables and need to drop and repopulate the database to run some performance tests. Using mysqldump, I can dump out the data. What steps should I follow next, to clear the database, and re-import? Will need to run this for different sizes of the database (i.e. tables with different number of rows) to calculate the db performance, so I need to make sure these steps can be replicated.
1
-
mysqldump can include the full DDL, including drop statements to kill previous installs of a table.Marc B– Marc B2012-10-31 15:15:08 +00:00Commented Oct 31, 2012 at 15:15
Add a comment
|
3 Answers
You might want to look at the options on mysqldump such as --add-drop-database and --add-drop-table. I'd probably go for --add-drop-database in this case.
1 Comment
Chaoley
Just for interests sake, would you have to re-grant user permissions if using --add-drop-database ?
1) take the dump
drop database db_name
create database db_name
mysql -u user -p db_name < dump.sql
I am sure this can be repeated any number of times. Its idempotent
answered Nov 1, 2012 at 21:02
Comments
From the MySQL console:
mysql> DROP DATABASE [dbName];
mysql> CREATE DATABASE [dbName];
mysql> USE [dbName];
mysql> SOURCE [pathToSQLDump];
answered Feb 14, 2014 at 20:21
