Copy table in mysql control center 0.9.2-beta

Posted on 2006-07-20
Medium Priority
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?
Question by:Titanium_Sniper
  • 2

Author Comment

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

Accepted Solution

f_o_o_k_y earned 1500 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)
Migration tolkit

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

Expert Comment

ID: 17146994
EMS Lite for MySQL is a great GUI tool... I like it better than Control Center.


Author Comment

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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Article by: Tammy
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

621 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