MySQL.software

[aza]

What software you use to operate with MySQL databases on Powweb hosting and for what purposes? (especially interested in freeware ones)

[VBman]

Here is a thread that talks about the free version of Mascon.
http://forum.powweb.com/showthread.php?s=&threadid=609

I would recommend phpMyAdmin which is written in PHP and ran from your site. Many here on the forum use it. You can find more info/download it here:
http://www.phpwizard.net/projects/phpMyAdmin/

[aza]

I already know phpMyAdmin and use it most the time. The problem appears with moving DBs from one server to local computer and then again to other server. What would you advice for this purpose? Which "dump" software you use?

[DeafNLoud]

PHPmyadmin has table and data dump features that are simple to do. Go to the PHPmyadmin homepage for details.

[devinemke]

PHPMyAdmin can dump the schema of a table or entire db to a text file which makes moving db's around a real snap. You can select structure, data or both in your dump. I have a webserver and PHP running locally on my machine so I can run PHPMyAdmin locally and another copy on powweb. If I make changes to my db locally I just dump them out into a txt and load the txt into my powweb db. I've never used mascon but I can't imagine it being much easier than PHPMyAdmin.

[middleground]

Hey guys,
Just wanted to ask a question- does the dump and load always work for you?

I had problems with (2) apps (phpWebSite, and XMB Forum) in loading the data, and got errors. It seemed that, in phpWebSite, the data is stored with code in the fields and this caused a problem on import- my thought was any code with a delimiter (I was using ; ) in it caused the error.

Has anyone else had this problem?

[aza]

i've looked over phpMyAdmin and didn't find any dump and "re-build" functions ... could you help me find them there?

[Catweasel]

Originally posted by aza
i've looked over phpMyAdmin and didn't find any dump and "re-build" functions ... could you help me find them there?

Disclaimer : I'm no phpMyAdmin guru, and istr there were problems with this.

Down towards the bottom of the table page (i.e. choose your database & table on the left, then look in the right pane) there's "view dump (schema) of table". Here, you can choose to "save as file". Above that, there's "Insert data from a textfile into table".

Below that, there's also "move" and "copy" database functions.

But I normally use MySQL-Front - http://www.mysqlfront.de, a Win32 app. Still under development and a bit clunky, but hey, it's free ;)