PDA

View Full Version : PHPmyAdmin Dump Reader?


Golden_Eagle
05-18-2003, 10:52 PM
I have a large 4MB dump from phpmyadmin and I would like to know if there is any software available that helps to read and edit this huge text file to assist in editting it.

I currently do not have a constant connection to the web and would like to somehow edit this file offline

Does anyone know of anything decent that can read and edit it?

raf
05-19-2003, 08:02 AM
If i remember correct, the dumpfile is just one huge sql statement and you can open it in notepad or wordpad.

But if you're frequently gonna edit dumpfiles, just install a mysql-server on your (offline) machine, and run the dumpfile to import data and structure. After editing, create a new dumpfile (exporting data and/or structure) which you upload to the server. If you use one of Firepages packages, installing MySQL, is very easy. More info:
http://www.codingforums.com/showthread.php?s=&threadid=3992

whackaxe
05-19-2003, 02:28 PM
for agood sql editor (after having installed the mysql server) get sqlyog from www.webyog.com