offline reading of a MySQL db - how do I do that ??

[Bell]

I am able to download the db for my TGP that uses Auto Gallery Pro - but what do I read that file with (offline) ??

is there a way to sort through all those
que entries offline ?? (not through
the server)

~Bell

[Chop Smith]

Bell, what is the file extention on that download? If it is the backup created by the program - sql.txt -, you can use a text editor, such as notepad, to read the sql statements. Actually even if it is unzipped .sql file, you can read it with a text editor.

HOWEVER, if you do not know sql, I would not advice you to attempt to do changes and then try to restore it.

Perhaps, if we knew more about what you were trying to accompanlish we could help you find a solution.

[Bunnyhop]

The best thing to do is dump the database into a text file.

Log into your webserver and run

mysqldump databasename > file.txt

mysqldump comes standard with mysql installations. You may need to modify the above a bit if you need to provide username/password authentication.

Then download the file.txt file and you can use any text editor you wish.

mysqldump provides several options to allow you to manipulate the format of the text too if it is necessary for you.

I'm not away of any programs that can parse a MySQL db file directory (besides MySQL itself).

[Pazz]

Or my favorite is phpMyAdmin and export the file and open it in wordpad/ notepad or what ever floats your boat. Of course editing online with phpMyAdmin is so easy it's better than doing it offline

[Bell]

Originally posted by Pazz
Or my favorite is phpMyAdmin and export the file and open it in wordpad/ notepad or what ever floats your boat. Of course editing online with phpMyAdmin is so easy it's better than doing it offline

thank you for sharing that information...



~Bell