TonyG
TonyG

Reputation: 1538

How to restore a duplicate database with MySQL Administrator?

I just started working with a client that has MySQL 5.5 and MySQL Administrator v1.2.17 over Windows 2012 Server. My task is to duplicate a live database into the same server - essentially copy dblive into dbtest.

I used the app to create a backup .sql file, without a drop table. I'd like to use the restore mechanism in this app, purely out of convenience and to be able to document a simple process for the client. But every resource I find is vague on detail, assuming that the restore will replace the original. So I'm hoping to get a concrete solution here.

The restore asks for Target Schema, whether Original or Another. This is the only option, it doesn't say "database name". (I'll accept a "duh, that's what you want".) The tip here suggests this should be simple and quick, but the follow-up comment says this app can't handle "big" databases. The .sql file for this is 250MB, I'm not sure if that qualifies as big.

This tip suggests using the mysql command-line, but there's no confirmation that it works for restoring to a different database name. Most other solutions I've found rely on complex queries, notes like "don't do that", twiddling with configs, etc. I'm hoping someone can propose a simple solution, even if not using this one utility. I'm not a MySQL stud, more of a developer, so please be don't beat me up. Thanks.

Upvotes: 0

Views: 113

Answers (0)

Related Questions