problem with mysql backup

[slikiceo]

Regards, thus I have a problem with my mysql database, I have done 4 days before the backup database and file I took off base, I deleted the database on the server, now I would like to restore the old database from my computers, but when uploading appear some errors and end can't finish procces.please for assistance. thanks

[felgall]

The only way to create databases is through cPanel. Have you actually created the database you want to upload to?

If you have database create statements in the file you are trying to restore from you'll have to delete that command before the rest of the file can run.

[php8ox]

I used to use a Windows xampp localhost setup.
I had backed up 30 different databases and then re-formatted, only to find later that the phpmyadmin backup files were corrupted and worthless. This has happened to me many times, depending on if you select tar.gz compressed backups and whether you have enabled that "feature" on a windows server through php.ini.

What a joke. I use only linux (i'm still a wimp, so I use ubuntu/xubuntu) for testing and building databases for online servers now. I loathe my time learning how to refactor code to work properly going from windows to linux: File functions, file references, links, database weirdness. Its just not worth it.

If you are having another problem, at least see if you can open the .sql database backup files in a TEXT-editor and read the files that way. You can copy and paste any readable just from that into phpmyadmin from C-panel or any other method.
other methods are:
ssh / commandline / http://www.webyog.com/en/ / http://navicat.com/ phpmyadmin / or write an install php script?