need help with Kloxo and Cpanel backup

[FileStorageHouse]

I have a backup from Cpanel It's about 555 MB Zipped and I am moving my website(database + content) to My Kloxo Server.

I am trying to put the database in PHPMYADMIN but the size is 1.2GB and the limit is 200mb.

Any other way to do it, from ssh maybe? i put the .sql files in server through ftp and I use ssh commands to put the database in?

I also searched before posting this for a quite while, and I saw a thread in wj about this and the command is this :

mysql -u username -p database_name < dumpfile.sql

And I have a few questions for those, Do i change username > to my Usernames database? and same with p?

and What about the password? what do i do with the password of the database?

Thanks if anyone can help, it will be a great help .

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
I made another thread in general section, can you delte that one admins if you find it.

 

[masterbator]

here it is:

mysql -uYOURUSERNAME -pYOURUSERNAMEPASSWD -hlocalhost YOURDBNAME < /path/to/yourdb.sql

the passwd is not database's
it's the username's passwd that you've created before

 

[FileStorageHouse]

Thank you very much

 

[FileStorageHouse]

I have a problem, my password has $%(*#(%_ in it. and everytime i put it in, it keeps on telling me

-bash $(_#$)_ event not found

 

[masterbator]

try to put quotation marks or backslashes before and after your password

 

[FileStorageHouse]

i put these in ' ' before and after the pass and it gaved me wrong pass i thinkg


ERROR 1045 (28000): Access denied for user '__________'@'localhost' (using password: YES)

 

[masterbator]

try with double quotes or change the pass to simpler characters :D

 

[deelow66]

try
http://anonym.to/?http://www.ozerov.de/bigdump/

 

[FileStorageHouse]

um. I restarted my Putty and now it went through ,but I dont see the database in my myphp

 

[nEw_boY]

Just change the damn password for 3 seconds and revert it back after you done using that trick.

Edit:
No idea about that.

 

[FileStorageHouse]

Just change the damn password for 3 seconds and revert it back after you done using that trick.

omg im no expert lol, go slow with me.

I restarted putty, and i put the command that masterbator gave me, and it worked.

But. I see a big list, and fasle/true bolean options

but When i go to myphpadmin page in kloxo i dont see the database..

I might be doing something wrong, or there is another step.

try
http://anonym.to/?http://www.ozerov.de/bigdump/

I have the sql already in the server, i uploaded it... i odnt want to do this all over again, its a pain.

 

[masterbator]

i think your import has failed, maybe some tables are broken
try splitting it using mydumpsplitter and then import them table-by-table

 

[FileStorageHouse]

im gonna try the method that deelow66 gave, i think that is the best bet.. I just read over the bigdump and what it does, it uses the files on the ftp server, so that sgood

thank you guys.. im gonna go bed tonight, i'll fix my site tmorrow. later

 

[awaiz007]

Use bigdump its the best for restoring big databases