Mysql question (Strickens) - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Mysql question (Strickens) (/showthread.php?tid=219895)

---

Mysql question (Strickens) - Sascha - 02.02.2011

Hi, I'm using Strickens mysql plugin, however it somehow closes connection sometimes (quite often)...
I guess there is a mistake in my script, however I fixed all errors and in the log it just says that mysql closed..
Is there any way to get whether the server is connected to the db?
so I could run a timer that checks whether it is connected and if not I could reconnect it...


thanks

---

Re: Mysql question (Strickens) - Steven Paul - 02.02.2011

could be a problem of your MySQL host. Btw what host are you using for MySQL

---

Re: Mysql question (Strickens) - Sascha - 02.02.2011

serverffs...
so is there any code to get whether the server is connected to the db?

---

Re: Mysql question (Strickens) - Steven Paul - 02.02.2011

don't use severffs for MySQL hosting. Try to use this http://www.freesql.org/freesql/mysql

---

Re: Mysql question (Strickens) - Sascha - 02.02.2011

I just want to know whether there is a function to get whether the connection exists or not...

---

Re: Mysql question (Strickens) - Steven Paul - 02.02.2011

try using HTTP function

---

Re: Mysql question (Strickens) - Sascha - 02.02.2011

example?

---

Re: Mysql question (Strickens) - Woet - 02.02.2011

Yeah, free remote MySQL databases are very helpful if you want to have a few seconds lag on your server and if you want your database to be deleted whenever the provider feels like it.

---

Re: Mysql question (Strickens) - Sascha - 03.02.2011

I'm just asking for the function guys....

---