Solved

Copy table in mysql control center 0.9.2-beta

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql statement to select and drop 13 49
how to get top 5 assets which having more tickets raised using sql 5 48
sql_mode 1 24
mysql between clause 2 25
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

803 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