[PlusEMU R2] Database not importing correctly

ano2k77

Member
Feb 4, 2013
466
30
Hi DevBest,

I'm moving to Plus's R2 so my catalogue made by UltraLulz works perfectly, now I'm having trouble importing the database so that the EMU works. I'm getting this error a quarter of the way when it's importing.

And when I refresh the database, only tables upto furniture have been created and no others which means there's no table for users, user stats and much much more. I've also tried opening the database.sql in Notepad++ and copying the whole SQL from Notepad++ and running it as a query but I still get the same issue, can someone please help me import it? I really need this to work. I'm using IIS and Navicat btw.

Thanks!
 

BenHands

Member
Oct 10, 2011
200
38
Clean your database table, make sure it's empty,

Go to Queries, new query,

And run this query: SET @@global.sql_mode= '';

Then, go to Tables, right-click, and run the full database again.


If that doesn't work, my mind draws a blank! :)
 

ano2k77

Member
Feb 4, 2013
466
30
Clean your database table, make sure it's empty,

Go to Queries, new query,

And run this query: SET @@global.sql_mode= '';

Then, go to Tables, right-click, and run the full database again.


If that doesn't work, my mind draws a blank! :)

I'll try this when I'm back on my VPS, thanks! :)
 

ano2k77

Member
Feb 4, 2013
466
30
Clean your database table, make sure it's empty,

Go to Queries, new query,

And run this query: SET @@global.sql_mode= '';

Then, go to Tables, right-click, and run the full database again.


If that doesn't work, my mind draws a blank! :)

I'll try this when I'm back on my VPS, thanks! :)
 

Users who are viewing this thread

Top