Solved

Copy table in mysql control center 0.9.2-beta

Posted on 2006-07-20
4
816 Views
Last Modified: 2008-02-01
I am working on a couple tables that are in use and I want to test my command to remove duplicate users but I dont want to mess up the database because getting the backup would take lots of work as they only back up the entire server, not the databases and people would get really mad.

Every time I try to copy the tables by exporting and importing the mysql Control center crashes

is there some easy way to make a copy of a table in mysql control center 0.9.2-beta


also i just realized as of this writing that i am using a beta release, is there a stable one availible?
0
Comment
Question by:Titanium_Sniper
  • 2
4 Comments
 
LVL 5

Author Comment

by:Titanium_Sniper
ID: 17146358
did I mention that This had to be done yesterday?
0
 
LVL 11

Accepted Solution

by:
f_o_o_k_y earned 500 total points
ID: 17146641
Are you using windows ?? I asume yes. There was alway a problem with Control Center.


Maybe try MySql Administrator (backup and restore)
http://dev.mysql.com/downloads/administrator/1.1.html
or
Migration tolkit
http://dev.mysql.com/downloads/migration-toolkit/1.0.html

In linux its much simpler.
mysqldump and then mysql
of course you need to change script. (tabloe name or database)
0
 
LVL 6

Expert Comment

by:chigs20
ID: 17146994
EMS Lite for MySQL is a great GUI tool... I like it better than Control Center.
http://www.sqlmanager.net/en/products/mysql/manager/download

0
 
LVL 5

Author Comment

by:Titanium_Sniper
ID: 17147289
thankyou, i just edited it after backing up with admin sql
i hope I didnt make any mistakes
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question