MyBB Community Forums

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

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

(2015-02-18, 03:38 PM).m. Wrote: [ -> ]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?

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

(2015-02-18, 03:59 PM).m. Wrote: [ -> ]^ 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?

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

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