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
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.
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.
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...
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.
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:
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
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?
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?
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.
