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 KWWH 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.

FileStorageHouse Reviewed by FileStorageHouse on 11th Nov 2011. need help with Kloxo and Cpanel backup 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 KWWH about this and the command is this : mysql -u username -p Rating: 5

[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)

[deelow66]

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

[masterbator]

try with double quotes or change the pass to simpler characters

[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.