Help, trying to upload database.sql and shows error

[HeartSeeker]

This user has been denied support.

So I zipped the .sql fil, it ws 260 MB and when i zipped it, .rar now it's 49.2 MB, so finally I can upload the db via the PhpMyAdmin in the cpanel!!


Now I uploaded it and it says:

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rar! ' at line 1


SCREENSHOT: http://i.imgur.com/bK2KbAW.png

Any help would be so appreciated! I want my site up now!!

Edit: Is it because it's a .rar file that I'm trying to upload and it needs to be .zip?

File may be compressed (gzip, bzip2, zip) or uncompressed.
A compressed file's name must end in .[format].[compression]. Example: .sql.zip

[.m.]

one of the suggestions was to use 7-zip utility and compress sql to sql.gz

[HeartSeeker]

This user has been denied support.

one of the suggestions was to use 7-zip utility and compress sql to sql.gz

I can't find how to compress sql to sql.gz = http://i.imgur.com/dJ2gX1O.png

Where?

EDIT: I compressed my .sql to zip and it says 63MB: http://i.imgur.com/Nmu2KJ8.png

So it's over the 55MB max upload size...

How to do .gz?

[.m.]

^ please use 7-zip freeware utility. after installing it, compress your sql file to gzip (see this image)

[HeartSeeker]

This user has been denied support.

^ please use 7-zip freeware utility. after installing it, compress your sql file to gzip (see this image)

Thanks.
It still 64MB.

The max upload is 55MB.

http://i.imgur.com/4RbXTJy.png

My host is not responding and I need to upload my db.sql by myself using Cpanel.
I tried (gzip, zip) and the file is 64MB.

Can I split it in parts?

Edit: UPLOADING IN bzip2, it's 51MB !!!

I'll message you back here

---

Ok now I uploaded it and it seem to work: it has been uploaded but it didnt say succesfully:
http://i.imgur.com/FyhtxsG.png

Now I got on my site and it says:


Access denied for user 'mybbuser'@'localhost' to database 'databasemybb'

What does that mean?

[Sazze]

You have to make sure it can connect to the MySQL server. Check your config.php file located in "inc"

[ThemeFreaknet]

You could try asking your host to temporarily increase the max upload size.