SA-MP Forums Archive
Getting back my MSQ database - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Getting back my MSQ database (/showthread.php?tid=545664)



Getting back my MSQ database - FunnyBear - 09.11.2014

Hey,

Around last year I made a server (not yet finished) with MYSQL on XAMPP, and it was on another computer. I've got another computer now, and I've got my server on a USB which has now been imported to my computer. The server starts alright, but there are some problems. Because it was running MYSQL, I lost of my databases and stuff like logging in doesn't work. Is there a way I get my database back on to MYSQL without having to creating a new one.

Making a new one is quite complicated, because I've got look through my whole script for each MYSQL database, then add it to my server (and I'll probably get it wrong).

Thanks,

Danny


Re: Getting back my MSQ database - Abagail - 09.11.2014

If you exported or have a base .sql file in your backup, you can import it using phpMyadmin, or something such as navicat. If you don't have the .sql backup, and no longer have access to the old computer then you'll have to re-create it.


Re: Getting back my MSQ database - FunnyBear - 09.11.2014

I've got a libmySQL.dll file in my server directory folder. Would that be it?


Re: Getting back my MSQ database - Sledgehammer - 09.11.2014

That wouldn't be what your looking for.


Re: Getting back my MSQ database - Abagail - 09.11.2014

libmysql.dll is a file needed for the MySQL plugin, and isn't a database. You should look for an ".sql" file.


Re: Getting back my MSQ database - FunnyBear - 09.11.2014

Quote:
Originally Posted by ******
Посмотреть сообщение
MySQL databases aren't stored with the server itself - if you didn't explicitly make a backup you don't have it.
Ok thanks. I guess I'll have to add them all in myself.

Thanks to everyone as well