Software

March 4, 2009

Is there some efficient way to run spell checking through HTML content inside MySQL tables?

mysql
Pancha asked:


I’m looking for some solution for this, preferably with a nice GUI.
Any pointers in the right direction would be greatly appreciated!
Thanks!

Filed under Software by administrator

Permalink Print 1 Comment

February 25, 2009

How do I export excel into mysql database?

mysql
ken asked:


Is there a program that will convert any excel spreadsheet into mysql. I don’t want a program that has to connect to the database from my computer, but more like a converter that will change the data of the spreadsheet to text like: “INSERT INTO `table` VALUES (”") etc…” Any ideas? thanks.
My website host does not allow remote connection to their databases.

Filed under Software by administrator

Permalink Print 3 Comments

January 24, 2009

What is the best/easiest way to backup a MYSQL database to sourcecontrol?

mysql
Superpappa asked:


Its a hosted account with PHP and phpMyAdmin. The source control is local subversion.
The idea is to easily see relevant differences, and I suspect that for example SQL code backup is not the best way to do that.
How is this better than PHPMyAdmin?
Was thinking of something like XML, or perhaps having just one item pr line.

Filed under Software by administrator

Permalink Print 2 Comments

October 4, 2008

What is the difference between mysql_fetch_object and mysql fetch_array ?

mysql
snehashish c asked:


What is the difference between mysql_fetch_object and mysql fetch_array ?

Filed under Software by administrator

Permalink Print 1 Comment

September 30, 2008

Which is the best tool to transfer data between mysql servers located in two different machines?

mysql
kashyap asked:


Even if the tool is a shareware also its ok for me, as i am ready to buy it. I can do it with dump function available in mysql but it gives error when database size becomes too large .I thank in advance for all those who replies.

Filed under Software by administrator

Permalink Print 1 Comment

September 25, 2008

How to move users and privileges from one MySQL server to another?

mysql
alex asked:


I used “mysqldump -A” to copy some databases out and then “mysql” to import them back into another server. This works ok but all the user logins and privileges are lost. Is there an easy way to move the users and privileges?

Thanks!

Filed under Software by administrator

Permalink Print 1 Comment

September 21, 2008

How do I start MySQL as a Windows service?

mysql
Kazuto asked:


Each time I try to execute the configuration, all but one don’t work. “Start service” has a red X next to it and the error says “Cannot create Windows service for MySQL. Error: 0″. Does anyone know how to fix this?

Filed under Software by administrator

Permalink Print 1 Comment