have not done this in a while need help.

[Vapour]

hey guys so i was updating my database for phx 3.1.1.0 and it messed up so i deleted the database and now i have for got how to re add the database i have the sql file but im confused on how to add it back. i use navcat premuim thankyou.

 

[Lee_01]

Copy the whole SQL, open Navicat and click F6 or go to tools > console and then paste the SQL code.
Be patient if it doesn't immediately paste as it can take a while depending on the size.
Once it's all pasted hit the enter button and it should create the tables and insert the content.
It'll tell you when it's done.

 

[Vapour]

Copy the whole SQL, open Navicat and click F6 or go to tools > console and then paste the SQL code.
Be patient if it doesn't immediately paste as it can take a while depending on the size.
Once it's all pasted hit the enter button and it should create the tables and insert the content.
It'll tell you when it's done.

i did what you said but now my EMU is playing up could you help me with this?


Scrinie :

 

[Lee_01]

There's an error with the points column, I presume this is under either the settings table or users table.
Either that or it's in one of the other tables when it shouldn't be. CTRL + F then type points and see what comes up.

If you have any more problems I can give you a SQL file.

 

[Vapour]

There's an error with the points column, I presume this is under either the settings table or users table.
Either that or it's in one of the other tables when it shouldn't be. CTRL + F then type points and see what comes up.

If you have any more problems I can give you a SQL file.

Could you send me a download to that SQL please

 

[Lee_01]

Sorry for the late reply, I was making myself a midnight snack haha

I've uploaded the SQL file to Dropbox:

You must be registered for see links

I used this on my old hotel and it seemed to work fine, any troubles though I have loads more SQL files dotted around my hard drive

You must be registered for see links