What free/shareware software to use to work with MySQL files offline.?

Question

I have some sql files saved as backup on my pc from a website i was building. I now need to extract some of the data from them to put into a new website.

All of the stuff I can see available is designed to work on these files directly online on a server. I've tried opening them in MS Access but it doesn't recognise the format.

Thanks

Answer 1

http://www.pcworld.com they have a download free to view off line and save.

Answer 2

I found quite confusing things in your question. Is it a database table back or just sql script backup? You need to identify it first.



If it is a table data backup file, you can open it with the type of DBMS you used before. eg. MySql, SQL2000, Access. If it is a CSV file, you can view with even a normal text editor like notepad and then you can feed that file to most of the DBMS system.

If it is a script file, you can execute it with any TSQL supported DBMS.



For the freebies for MySQL, I suggest you to use wampserver. It is a solution for PHP + MySQL development.

Answer 3

i think you are trying to achieve the impossible. you need to understand the difference between a file based database management system and a server based dbms. with access, which is file based, you can easily open the database "offline" because you only need MS Access to access the data. It works pretty much like Word etc. However, mySQL is a client-server database. the database resides on the server and the mySQL engine needs to be running and in order for your mySQL 'client' to be able to access the db (i.e. the program you are using to access the mySQL database whether its the mysql command line tool pr other GUI tools).



you therefore cannot access the mySQL backup unless you have a mySQL Server running and your database restored within it.



look at:



http://forevergeek.com/geek_articles/access_vs_mysql.php

Answer 4

mysql file is just a file with mysql commands, pretty much like a batch file,( if we are talking about the same thing) You should be able to open it with notepad in windows or nano on linux.:)

Answer 5

flow to regulate panel-internet option- then delete Cookies, Offline information, sparkling Hisatory. hence u can sparkling ur cache and temp information. desire this allows. also there's a software said as window washer, by creating use of this u can sparkling all temp information.

Answer 6

Install Apache & PHP?



On windows there's a single install from www.wamp.org or similar.

On Linux apache and php will be in the repositories.



Apache will happily serve on localhost.

Answer 7

Download SQLYOG and use it to open/edit/execute your files.