MySQL.software

aza · 2-6-02, 12:05 PM

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

2-6-02, 12:38 PM

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 · 2-6-02, 02:24 PM

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?

2-6-02, 04:47 PM

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

devinemke · 2-6-02, 11:46 PM

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.

2-7-02, 08:42 PM

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 · 2-8-02, 02:28 PM

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

2-9-02, 11:08 PM

Quote:

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

2-6-02, 12:05 PM	#1
aza everything has beauty Join Date: Jan 2002 Location: Kyiv, Ukraine Posts: 268 Reputation: 5	MySQL.software What software you use to operate with MySQL databases on Powweb hosting and for what purposes? (especially interested in freeware ones) __________________ Yours faithfully, Yaroslav Zaremba

2-6-02, 02:24 PM	#3
aza everything has beauty Join Date: Jan 2002 Location: Kyiv, Ukraine Posts: 268 Reputation: 5	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? __________________ Yours faithfully, Yaroslav Zaremba

2-8-02, 02:28 PM	#7
aza everything has beauty Join Date: Jan 2002 Location: Kyiv, Ukraine Posts: 268 Reputation: 5	i've looked over phpMyAdmin and didn't find any dump and "re-build" functions ... could you help me find them there? __________________ Yours faithfully, Yaroslav Zaremba

2-6-02, 12:38 PM	#2
VBman Guest Posts: n/a	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/

2-6-02, 04:47 PM	#4
DeafNLoud Guest Posts: n/a	PHPmyadmin has table and data dump features that are simple to do. Go to the PHPmyadmin homepage for details.

2-6-02, 11:46 PM	#5
devinemke broken tv Join Date: Dec 2001 Location: NYC Posts: 268 Reputation: 13	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.

2-7-02, 08:42 PM	#6
middleground Guest Posts: n/a	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?