Transferring database

[Bintzer]

I'm trying to find the easiest way to transfer a database from one computer to another...
I can't just export it into a .sql file because it is too large to import.
Also breaking it up into smaller .sql files is way too obnoxious and time consuming..
Is there an easier way to do this?

 

[Pro Warbringer]

Just send the whole server in .rar or in .zip away?

 

[Bintzer]

o.o The whole server?
You mean the whole database?
If so, where's that stored?

 

[Bintzer]

I tried copying the whole database from mysql/data/ on xampp for windows and extracted it into my linux mysql,
but when I try to load the database in phpmyadmin it only shows 8 of my 33 tables even though in the database name it says theforgottenserver (33)
I used the same name so I'm guessing the problem is from going from xampp to linux mysql...

Anybody know a way to do this?

 

[klekSu]

Yes, go cmd, then

cd /C:/yourdirectory/xampp/mysql/bin/

then

mysqldump.exe -u root nameofthedatabase > C:/newfilename.sql -p

then make a new database on linux and do in putty

mysql -u root newdatabasename < /directory/newfilename.sql -p

rep?

 

[Bintzer]

Worked great

 

[Mindez]

next time just export and import it, a lot easier

 

[Bintzer]

I can't just export it into a .sql file because it is too large to import.
Also breaking it up into smaller .sql files is way too obnoxious and time consuming..

Yea..

 

[klekSu]

next time just export and import it, a lot easier

;s

I'm trying to find the easiest way to transfer a database from one computer to another...
I can't just export it into a .sql file because it is too large to import.
Also breaking it up into smaller .sql files is way too obnoxious and time consuming..
Is there an easier way to do this?

I believe he cannot import if doesn't know how to edit my.cnf.

 

[Migxxx]

I believe he cannot import if doesn't know how to edit my.cnf.

and also there is a limit on 20MB, the default one is 3 mb but there is a limit of 20MB

 

[Bintzer]

It's solved lol, Migxxx pmed me the best way to do it. xD

 

[Guitar Freak]

It's solved lol, Migxxx pmed me the best way to do it. xD

Mind posting the PM here so everybody having the same problem can solve it too? :thumbup:

Cheers~