[mySQL] Copy Colomn From 1 Database To Another

Dec 22, 2007

I'm trying to copy the contents of a column from 1 database to another. I need to do this as the contents in the current database have got messed up after an upgrade.

The DB structure

table forum_msgs
It contains a column called "topic_id".

Basically I need to copy over the topic ID fields from the "old" database into the "current" database into table forum_msg replacing any values that are currently in the column "topic_id"

I tried this but it doesn't seem to work correctly. Any ideas how it should be done?

insert current.forum_msgs
( topic_id
)
select topic_id
from old.forum_msgs

View 4 Replies


ADVERTISEMENT

Copy An Account From Another Server Via WHM - Cannot Copy Mysql Database

Oct 7, 2008

In previous thread we made few manual transfer of our domains.

We also made some automated migration of few domains/sites using Web Host Manager's Copy an account from another server feature.

All the files and other settings were properly transferred from old server to new server, but only the mysql database is not visible on new server. I am unsure if the same got copied to new server.

View 4 Replies View Related

Copy Database From Another Virtual Private Server (VPS)

Aug 23, 2008

I've a backup on another server and wish to copy that database onto the new server.

Is there any easy way of doing so?

I can only access the VPS (backup) via it's IP and SSH is working fine. PhpMyAdmin on the server is playing up, as well as a lot of other php-mysql applications.

View 4 Replies View Related

Plesk 12.x / Linux :: Copy Database To Other Domain

Jul 7, 2015

Just updated to V12 and noticed you can't copy a database from one domain to another as easy as before. So doing any testing is much harder. Is this correct or am I missing something...

View 5 Replies View Related

Plesk 12.x / Linux :: Database Copy Hanging In New Version

Dec 23, 2014

After the micro update, the database copy function started to hung even just for copying database with 4 tables with less than 10 rows of recrods. Although I followed the link below to remove the hung database copy and remove the unfinished database copied. URL....However, no successful database was copied at all even after the timeout was adjusted.

View 1 Replies View Related

Plesk 11.x / Windows :: Copy Mssql Database In Panel

Feb 5, 2014

I have vps server with win server 2008 and Plesk 11.5.30. when i am trying to copy Mssql Database trough the panel i have an error: " Unable to copy database ". In the %plesk_dir%adminlogs under the php-error.log i have this error:

"[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Database cloning failed.
[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Task failed: id=163, pid=9700, type=db-clone, error=Unable to clone database."

View 7 Replies View Related

Copy MYSQL To Another Server.

Sep 4, 2007

I would like to copy all MYSQL databases, users, etc.. to another server.

One server is RHEL 4 and the other is RHEL5.

What do I need to copy to insure everything is moved over,

View 14 Replies View Related

How To Get Copy Of All Mysql Databases Into Individual Tar.gz Files

Mar 26, 2009

I'm trying to use the "mysqldump" command to get a copy of all databases on the server...

but I need each database to go into a "databaseXYZ.tar.gz" file.

Does anyone know how to do this? So far, I can only get all the databases into a single file. But I need each database to have its own file.

View 4 Replies View Related

Big Mysql Database 4gb

May 11, 2008

i been trying to move my server.. But mysql database is quite big and restoring takes ages 10 12 hours.. is there anyway i can make it quick because database dump takes 10 15mins but restore takes 12hours and it should be a way to make that quick

View 14 Replies View Related

Rsync Mysql Database

May 19, 2009

how can i setup rsync to backup just mysql database (if possible) every 6 hours or so.

View 14 Replies View Related

Rebuilding MySQL Database

Apr 24, 2009

I have are the .frm, .MYD, .MYI how do I restore/rebuild the database?

View 3 Replies View Related

Reloading A Mysql Database

Jul 13, 2009

My server admin linked me to this:

[url]

I'm using a cpanel based server, but I can't get this to work.

It requires I be in a directory I figure (this step isnt included)

so I type cd /home/username/public_html/

And then i follow the commands. but it doesnt work.

Basically i need to take a mysql database that I uploaded to my directory, and load it back into a database. :@

View 9 Replies View Related

Get Mysql Database From Shell

Apr 14, 2007

I have a problem getting mysql to start, so I am planning to setup a new server and move all the mysql databases to a new server.

The problem is I normally get mysql databases when mysql is running by using mysql command lines. Now that I cannot start mysql, I cannot use that method.

Is there a mysql directory that contains all the mysql databases for me to tar it up and untar it on a different? If there is a directory that contains all the mysql databases, do I need to exclude some files/folders so it doesnt conflict with the files/folders on my new mysql server?

View 3 Replies View Related

Repait All Database In Mysql

Jul 29, 2007

we have whm in my server

in whm is one part to name

Repair Mysql Database

this is only for one database

how may i repaired all database in my server?

View 8 Replies View Related

How To Protect Mysql Database

Jan 22, 2008

what steps procedures need to be done to keep your database as safe as possible from the hackers. Anyway to be alert when someone got into your db and try to dump, alter your database?

View 4 Replies View Related

MySQL Cannot Connect To Database Via PHP

Dec 1, 2007

I got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database.

It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs.

I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS.

I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem.

All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts.

I just added an hourly crontab so as to restart the MySQL server as a stop gap.

View 7 Replies View Related

Backup BIG MySQL Database

Nov 29, 2007

What is the recommended method of backing up big MySQL database of size 2 GB ?

Quote:

# mysqldump gallery > gallery.sql
mysqldump: Got error: 1017: Can't find file: './gallery/10tir_user_group.frm' (errno: 24) when using LOCK TABLES
#

I checked the table, it is fine, but can't do the backup.

Quote:

mysql> check table 10tir_user_group;
+-------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+-------+----------+----------+
| gallery.10tir_user_group | check | status | OK |
+-------------------------+-------+----------+----------+
1 row in set (0.07 sec)

mysql>

View 13 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved