a question about MySQL

Question

Post reply

a question about MySQL

bb2005

Newbie

Points: 1
More actions
October 29, 2008 at 10:17 am

#195151

Hi,
sorry to bother you here about a question about MySQL.
I tried SSH to transfer a huge database from the old server to the new one, is there is a way more easy ??? because I'm not a programmer, and SSH not easy to use.
if there is a way to transfer the website including the database, it will be perfect.
best regards

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 1

You should post you question on a MySQL forum.

Try the MySQL forum at http://www.dbforums.com/

Wilfred van Dijk SSCrazy Eights Points: 9003 More actions · Answer 2

You should post you question on a MySQL forum.
Try the MySQL forum at http://www.dbforums.com/

Or do you mean migrating from MySQL to MSSQL ?

Wilfred
The best things in life are the simple things

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 3

Nothing's perfect and what do you mean by ssh. The remote shell? That has nothing to do with transfers, that's a way of connecting.

jgrubb SSCrazy Points: 2542 More actions · Answer 4

There's actually a forum for non MSSQL questions as well

http://www.sqlservercentral.com/Forums/Forum61-1.aspx

As to moving a database, it's a file, or many files, depending on the Storage Engine. Treat it like a binary file copy. If you MIGRATE to another DB on another system (esp. if it's to MSSQL) that's something different.

Scalability Doug SSCertifiable Points: 5351 More actions · Answer 5

MySQL provides the MySQLDump command. It can be run from both Windows (assuming the MySQL client/engine is intalled on Windows) and in *nix OS's.

mysqldump --host={host name or IP} --user={user name} --password={pwd} {database} | mysql --host={host name or IP} --user={user name} --password={pwd} -C {database}

DAB

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 6

jgrubb (10/31/2008)
There's actually a forum for non MSSQL questions as well
http://www.sqlservercentral.com/Forums/Forum61-1.aspx

The "Anything that is NOT about SQL!" forum?

You could also say that is the "Quantum mechanics" or "Medieval History" forum, but he would probably still be better off going to a forum where there are actually people that know something about MySQL to answer his question, instead of posting on the SQL Server 2005 Backups forum.