Solved

Copy table in mysql control center 0.9.2-beta

Posted on 2006-07-20
4
810 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
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…

829 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