MySQL & PHP TidBits

Clone MySQL Database to new database via. commandline:

1
2
mysqladmin create <destination db name> -u DB_user --password=DB_pass && 
mysqldump -u DB_user --password=DB_pass <source db name> | mysql -u DB_user --password=DB_pass -h DB_host <destination db name>

Clone MySQL Database to existing database via. commandline:

1
mysqldump -u DB_user --password=DB_pass <source db name> | mysql -u DB_user --password=DB_pass -h DB_host <destination db name>
  • You may use these HTML tags: <a> <abbr> <acronym> <b> <blockquote> <cite> <code> <del> <em> <i> <pre> <q> <strike> <strong>

  • Comment Feed for this Post
Gå til Top