Hi!

I've just put version 1.02 up. The main new features in this are:

1. Mysqldump functionality. You can now dump your database into a text file just like the mysqldump utility. For those who are not familiar, this means your data will be recreated in a text file as a series of SQL commands. You can then move this to another server, even another type of database.

2. Import/Export improved. You can now specify what field names you want to import/export.

3. Direct connection. If you only have one database, you can just put the login info in the config file and go straight into that database, useful if you are not managing a mysql server, but rather just your own database.

I think there are still a few issues left in the mysqldump as we didn't have a chance to test it as fully as we'd like, so please don't rely on it 100% just yet (i.e. don't assume that it's a perfect copy of your data just yet).

We will most likely be putting up a new version in the next couple days as we wanted to add the ability to read back in a sql file (so you could dump and then restore all from the web), and at that time we will tighten up some of the dump features.

But please, do have a look and let me know (through the forum) if you find any bugs.

Cheers,

Alex

--
Gossamer Threads Inc.

Ok, if life is a bed of roses, why do I find the thorns?

I installed the new version, just copied it over the old one.

Things were updated, and I didn't have to change any defaults in the .cfg to make it work on Solaris. not bad.

But, I can't find an option for the 'sqldump', although I see it in the source code.

Also, the version numbers are hard-coded into the templates, it seems.

Isn't that what the $VERSION variable should be for?? It would help cut confusion.



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Hi Pugdog,

You should see SQL dump once you have selected a database. Is it not there? Did you update all the templates as well?

Cheers,

Alex

--
Gossamer Threads Inc.

Yeah ws_ftp.log says it all updated.

I did a search for 'dump' in the templates, and it looked like the header.txt file didn't update. Working now.

Right versions and everything ;)

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Couldn't the version # be part of the global, or passed $config variables?

The mysql.cgi and mysql.cfg should always be the same version #, even if the .pm files lag behind, or even advance.


The _ideal_ would of course have 1 version number for all the released files, in the $config hash, and update the version # of the various .pm files even if the code didn't change.

It helps cut confusion to have all versions at the same level, and to set the version in the "config" file for the program version, and in the modules for the module version (but report _only_ the program version as the running version).



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Very nice, Alex...I really like the new and improved EXPORT and IMPORT features.

Thanks!

Regards,

I agree, really a very nice work !

May i suggest just 2 little things.

I often have HTML in my datas.
It will be interesting to HTMLescape fields before showing them (browse/select view)
For my own use i replaced :
<TD>$ary[$i]</TD>
with
<TD><pre><xmp>$ary[$i]</xmp></pre></TD>

using pre tag $ary[$i] =~ s/(\r|\n)+/<BR>\n/g; is no longer useful.

Thanks.

Hi Alex,

I just downloaded the new version of MySQLMan and I am trying to export our database - to get it ready to move to a new server. However, I am unable to export I receive an error "Access denied, something about a password "Yes"?

I need to get our entire database moved (52 tables) to a new server - would SQLdump be better to use?

Any help would be appreciated.

Donm

I guess you have a virtual host or something where your database is not on localhost and the user of the database has no rights to write on your webspace. You could write a little script to export the tables and then import them again.

Regards

Niko