maxieduncan

Monday, 7 June 2010

Copying databases with mysql

To copy the database use mysqldump:

mysqldump -u root <DATABASE_NAME> <DUMP_FILE>.sql;

To create the new database:

mysql
mysql> create database <NEW_DATABASE_NAME>;
mysql> use <NEW_DATABASE_NAME>;
mysql> source <DUMP_FILE>.sql;
Posted by at
Labels:

2 comments:

  1. Max Duncan3 February 2011 at 05:19

    Got error: 1016: Can't open file: '...' (errno: 24) when using LOCK TABLES

    table_cache might be too small.

    Try --lock-tables=false on mysqldump.

    From: http://mysql.bigresource.com/Track/mysql-L5WFTgJm/

    ReplyDelete
  2. Max Duncan8 March 2011 at 13:54

    Or --skip-lock-tables

    ReplyDelete

Subscribe to: Post Comments (Atom)