[CalEvans]

basically, you select 2 databases, they can be on 2 different servers as long as you are connected to both of them. It will then generate SQL to make one match the other (Create tables, alter tables, drop tables, etc.) It will save it to the clipboard or to a file.

Very cool feature. I use it a lot when getting ready to roll to production. I sync my development and production boxes and then use the script that it generates as part of my roll. (After reading it carefully myself)

HTH,

=C=

[CalEvans]

tim wrote on Feb 3 2003, 02:42 PM:

Hi,

Thanks for SQLyog, it installed without a hitch and is easy to use. My problemette is that I'd like to acually see my data but instead the fields are marked “BLOB dblclk to view data” and if I dblclk I just see the contents of 1 field. Is it possible to view all the data in all the fields? 😮

Tim

Quote:

I'd like to acually see my data but instead the fields are marked “BLOB dblclk to view data” and if I dblclk I just see the contents of 1 field.

Press CTRL+L

=C=

[CalEvans]

QUOTE

Have been forced at an advanced age to try and figure out how to operate a mixed program bag.

Sorry to hear it.

QUOTE

1. find out how to erase data from a MySQL database and leave the structure intact. ( Cleanup trial data)

Using SQLyog:
* Select the table in the left hand navigation tree.
* Right click on it
* Select 'Empty Table'

QUOTE

2. Export data from the MySQL DB to something more useful than the pathetic Delphi front end I am stuck with. (Something easier like Approach)

Using SQLyog:
* Create a result set (enter select * from tablename in the command window area, press F5.)
* Right click on the result set (the data that just appeared below the command window) and select 'Export Result set' You now have 3 options, 2 of which are useful in this situation. CSV and XML.
* Select a file name and any appropriate options. (You may have to experiment a little, different programs like difference CSV options.
* Open Excel and open the export file you just created. I know Excel will open CSV's, I THINK it will also open XML.
Now you should be able to slice, dice or export your data into anything you like. (Sorry, I'm not familiar with Approach.)

QUOTE

3. Eventually get this data to a Website.

Easy Way
* Slice, dice and scrub the data until it looks the way you want it to then use Excel to save as HTML. Push the resulting file to your web server. Optionally, if you get to the point where you can extract the data using SQL statements and don't care about the formatting you can use the Export feature described above to export the file as HTML.
Hard Way
* Install and configure PHP and MySQL on your web server.
* Write a program that will extract, format and present the data in the way you want it to.
(Note, I almost ALWAYS use the hard way.)

Sorry you got burned. I hate it when that happens. Makes us consultants look bad.

HTH,
=C=

*
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
*

[Author]

Posts