1
vote
0answers
34 views

Transfer user data of a Tigase server

I'm trying to transfer a Tigase XMPP server from an Ubuntu VPS to a CentOS VPS. Unfortunately there isn't any official documentation available and I need to experiment in order to preserve all of the ...
0
votes
0answers
56 views

ERROR! Server quit without updating PDI file

My hosting provider migrated my vps instance and after the migration I encountered this error. I check the error (/var/lib/mysql/*.err) file and I got this: 140113 11:01:57 mysqld_safe Starting ...
1
vote
2answers
966 views

What's the best way to migrate a MySQL database?

We are moving a busy eCommerce site from one server to another. It's a PHP application that uses MySQL. phpMySQL is not installed on either server. We use Navicat Essentials for MySQL to manage ...
1
vote
1answer
72 views

How to properly migrate mysql server?

Currently I am dealing with server migration. I have mysqldump --all-databases dump, which contains also mysql and might be information schema databases. All I need is somehow safely and fast ...
1
vote
2answers
698 views

How to migrate old redmine server to a new one upgrading version and changing DB engine

I am planning to migrate my Redmine (1.0.5) to a new machine. I would like to upgrade Redmine to latest version and change the database from MySQL to Postgresql with this migration. My plan A is: ...
0
votes
2answers
58 views

Testing after migrating LAMP install on CentOS 6

I copied the /var/www/html/site directory to a new server and all of the /etc/httpd conf files, installed the necessary Perl modules, php, and ran cat mysqldumpfile.sql |mysql db_name to import the ...
0
votes
1answer
88 views

Move MySQL master

I currently have a master db server (lets call it db1) and 6 slaves (slave1-6). I've setup a new server (db2) as a slave of db1 and it's in sync. I want to change all the slaves to use db2 instead of ...
-2
votes
1answer
80 views

MySQL - complete server migration (Ubuntu) [duplicate]

Possible Duplicate: How to copy and move mysql database Dump all databases with SSH access I'm setting up a new dev machine, and I have the old one sitting right next to me. I'd ...
3
votes
2answers
1k views

Migrating from MyISAM to XtraDB

Just a few questions that I just can't find anywhere about migrating to XtraDB. My group has been using MyISAM dbs for production and was wondering how hard is it to migrate to Percona's XtraDB and ...
1
vote
2answers
268 views

Saving MySQL databases without mysqldump

I need to back up some of my databases and migrate them over to a new server. I would use mysqldump , but the problem is that I'm having issues starting mysqld/mysql (part of the reason I'm ...
3
votes
3answers
1k views

Where do I find .SQL files on Ubuntu Server?

I am migrating web servers. I'm kind of stuck on migrating the MySQL databases. I was wondering where to find the .SQL files, that I need for migration, under Ubuntu Server. I think the .SQL files are ...
0
votes
1answer
52 views

Questions about migrating a web server

I am about to migrate my web server. I am using Ubuntu Server on both systems. I've never done this and I need to know what I should look out for. Can I just copy the var directory? I have many ...
0
votes
1answer
127 views

switching master with minimal downtime

Currently have a MySQL replication setup in which Master A is replicated on another server db Slave B. I'm shutting down the server that hosts Master A and need to start a new server that houses ...
1
vote
0answers
154 views

Migrating a Magento CE 1.3 database to Magento EE 1.10 database?

I need to migrate a Magento 1.3 Community Edition (CE) database to a 1.10 (maybe 1.11) Magento Enterprise Edition (EE) database. Only the database is needed. Templates, extensions etc. will be ...
1
vote
1answer
133 views

Split existing LAMP to have a seperate webserver and database

I have a LAMP server currently running. It's been falling over a lot because there is too much stress on the DB. I'd like to split the DB out of there and run it on a separate machine. I have about ...
3
votes
3answers
185 views

Question: MySQL db Migration from Server(A) to Server(B), which tables?

When migrating a MySQL database from Server(A) to Server(B) which tables should be dumped and migrated to Server(B), including user grants? I don't want to have to manually re-enter user accounts and ...
1
vote
2answers
479 views

MySql raw binary data files copy 5.0 > 5.1

We are in the process of preparing a data migration of some fairly big DB (200GB), InnoDB tables from our old server to the new servers. The data is very index heavy and trying to migrate the data via ...
0
votes
1answer
1k views

Mysql: Innodb error when migrating mysql from linux to windows

I have migrated my data directory for an InnoDB mysql server from a linux machine to a windows machine. I started the server up, selected the database, and tried to query a table. Got the error "Table ...
1
vote
3answers
2k views

How to migrate from regular MySQL to Percona Server in production?

I'm running MySQL 5.0 in production on CentOS. How do I migrate to Percona Server 5.1 safely? The documentation of Percona Server doesn't include any information on migrating. Any help is greatly ...
1
vote
2answers
541 views

Migrating mysql 4 to mysql 5

This seems to me to be a common use case, so I'm surprised so little information is about it, so sorry if it's a duplicate, but I have searched. :) I'm migrating a clients website from one CMS to ...
1
vote
1answer
231 views

Can I change a MySQL table back and forth between InnoDB and MyISAM without any problems?

I have a site with a decently big database, 3Gb in size, a couple of tables with a dozen million records. It's currently 100% on MyISAM, and I have the feeling that the server is going slower than it ...
0
votes
1answer
74 views

How to migrate a MySql database to a SQL Server database safely?

I have a MySql database (tables + data) I wish to move to a Sql Server 2005 database keeping data intact (I know there will be some minor differences in data types). I'm looking for any tutorial, ...
0
votes
1answer
304 views

MySQL migration FROM SQL Server convert bit to bit instead of tinyint

I have plenty of tables with SQL Server bit-type fields. When I run these through the MySQL Migration Toolkit, it seems by default they're converted to tinyint. This sucks for my code, because it's ...
1
vote
2answers
296 views

MySQL Migration Toolkit syntax error when creating Sql Server diagram object

I have another syntax error when migrating a diagram. I'm not certain this diagram is necessary, but it would be nice to have a smooth migration, and this is all that's standing in the way. The error ...
1
vote
2answers
177 views

MySQL Migration Toolkit syntax error when creating schema

There is something wrong with the SQL after this error, and I'm not sure what. Error: You have an error in your SQL Syntax. Please check the manual that corresponds to your MySQL server version for ...
1
vote
5answers
135 views

MySQL: Keep the 'frontend', move the db to another computer

We have this MySQL database working in a production environment, and we need to move the database to another, unused server with more space. Our problem is, we already have really huge amounts of ...
3
votes
2answers
1k views

Fastest way to move multiple databases to a new server

I have several small to medium sized mysql databases, say about 40 and I need to migrate them from one whm server with different cpanel accounts to another one with the accounts set up from the ...
2
votes
2answers
180 views

How can I consolidate multiple MySQL servers? [duplicate]

Possible Duplicate: How to copy user priviledges with MySQL? I recently migrated a bunch of under utilized physical servers to one powerful server running Xenserver. I then turned one ...
0
votes
2answers
78 views

Migrated to new server, DNS setup >48 hrs, some MySQL inserts from domain still show up on old server

Title says it all - I've migrated to a new dedicated server at a different IP.. It's been more than 48 hours since DNS was setup. Some MySQL inserts (standard php variables invoke mysql) from at ...
1
vote
1answer
323 views

Migrate servers without losing any data / time-limited MySQL dump?

Is there a way to migrate from an old dedicated server to a new one without losing any data in-between - and with no downtime? In the past, I've had to lose MySQL data between the time when the new ...
4
votes
3answers
1k views

How to migrate from MySQL to SQL Server 2008

I have MySQL database backup file (Mysql version 5.1) and i want to restore it in Sqlserver 2008 how do i restore it?
3
votes
1answer
434 views

Best way to migrate from MySQL to PostgreSQL

I have to migrate a MySQL database to PostgreSQL. I have tried the mysqldump with --compatible = postresql. I have seen that some poeple use ETL like Talend to make the migration but you must describe ...
1
vote
2answers
789 views

How can I migrate my Redmine deployment from MySQL 5 to PostgeSQL 8.2?

I have full access to both databases, but clearly a MySQL dump file isn't going to import cleanly into Postgres. Are there any good step-by-steps for migrating from MySQL to Postgres?
1
vote
3answers
253 views

MYSQL to MSSQL migration

I have to move a MYSQL Database to MSSQL. I'd like to know if there's a tool that could automate this process a bit, at least for the tables and views.
0
votes
1answer
232 views

How to migrate from Oracle RDB for OpenVMS to MySQL in Windows?

I have a legacy Alpha server with a RDBMS database. This db is replicated in a MySQL db with many bad php scripts that drops all the tables and takes everything from the Alpha. This works very slow ...
3
votes
4answers
928 views

Fastest way to move MySQL database to a new system while minimizing downtime?

I'd like to minimize downtime (during the "cutover" period). We're running on EC2 with the data on an EBS volume. Is it safe to take a snapshot of the database volume while it's running and use that ...
0
votes
2answers
1k views

Login Using MS SQL Express: Success! Migration Toolkit login: fail?

(no responses from my identical post on the MySQL forums & StackOverflow, so I'm hoping to have better luck here) I'm trying to migrate a MS SQL database for a friend. I do not have physical ...
2
votes
1answer
1k views

Request Tracker migrate PostgreSQL to MySQL

I am in the process of migrating a request tracker 3.6 instance from one server to another. The old server uses PostgreSQL and the new one will use MySQL. Is there a way to migrate the data from one ...