MyBB Community Forums

Full Version: Import Database MySQL Error [$20 REWARD]
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
[Image: 63f355cc25da36a38f7f67827e5b30df.png]

Any idea? Been stuck at this part for a while. Fresh new import. Willing to pay $20 to who ever fixes this for me.
looks like character encoding is incorrect for the database ..
(2016-08-09, 05:29 PM).m. Wrote: [ -> ]looks like character encoding is incorrect for the database ..

Yes, indeed. But i'm unsure what to do? I've literally just downloaded this database on my up-to-date VPS hosting MyBB and with all the correct settings. Now I've literally bought a new server and tried importing it and im getting these errors. 

[Image: 72108edb9409e643d2a695468840030d.png]

What shall I do?

Increasing the bounty to $20. I need this fixed ASAP.
Hi,

Try changing the file's extension to ".sql.zip", rather than ".sql.gz".
(2016-08-09, 05:47 PM)Euan T Wrote: [ -> ]Hi,

Try changing the file's extension to ".sql.zip", rather than ".sql.gz".

How can I change this without premium Win-rar?
(2016-08-09, 05:57 PM)Romeo19 Wrote: [ -> ]
(2016-08-09, 05:47 PM)Euan T Wrote: [ -> ]Hi,

Try changing the file's extension to ".sql.zip", rather than ".sql.gz".

How can I change this without premium Win-rar?

http://www.mediacollege.com/microsoft/wi...hange.html

Make sure extensions are displayed, then right click the file and rename it, changing ".sql.gz" to ".sql.zip".
(2016-08-09, 06:14 PM)Euan T Wrote: [ -> ]
(2016-08-09, 05:57 PM)Romeo19 Wrote: [ -> ]
(2016-08-09, 05:47 PM)Euan T Wrote: [ -> ]Hi,

Try changing the file's extension to ".sql.zip", rather than ".sql.gz".

How can I change this without premium Win-rar?

http://www.mediacollege.com/microsoft/wi...hange.html

Make sure extensions are displayed, then right click the file and rename it, changing ".sql.gz" to ".sql.zip".

Had high hopes this would resolve it. Sadly not. 

Honestly who ever can fix this for me I'll pay you via BTC. I'm wasting time every hour, need this up! 

https://gyazo.com/449938b8f78d1e173baaf8e4b2da2e95.gif
Hi,

How did you do the export?

If you want, you can PM me with details to access the new server and the dump file and I'll see if I can figure out what the problem is.
(2016-08-09, 06:30 PM)Euan T Wrote: [ -> ]Hi,

How did you do the export?

If you want, you can PM me with details to access the new server and the dump file and I'll see if I can figure out what the problem is.

I exported the file via MyBB admin CP. Shall I try it via phpmyadmin? My VPS is still running, but it's ending soon so that's why I need to change it fast haha.
(2016-08-09, 06:32 PM)Romeo19 Wrote: [ -> ]
(2016-08-09, 06:30 PM)Euan T Wrote: [ -> ]Hi,

How did you do the export?

If you want, you can PM me with details to access the new server and the dump file and I'll see if I can figure out what the problem is.

I exported the file via MyBB admin CP. Shall I try it via phpmyadmin? My VPS is still running, but it's ending soon so that's why I need to change it fast haha.

Yeah, try exporting it through phpMyAdmin. I never use the ACP export tool personally.