Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Backup and Recovery

Interview Question :: What free/shareware software to use to work with MySQL files offline

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

Answers to "What free/shareware software to use to work with MySQL files offline"

RE: What free/shareware software to use to work with MySQL files offline?
http://www.pcworld.com they have a download free to view off line and save.
Vote for this answer ::

RE: What free/shareware software to use to work with MySQL files offline?
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.
Vote for this answer ::

RE: What free/shareware software to use to work with MySQL files offline?
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.
Vote for this answer ::

RE: What free/shareware software to use to work with MySQL files offline?
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.:)
Vote for this answer ::

RE: What free/shareware software to use to work with MySQL files offline?
Download SQLYOG and use it to open/edit/execute your files.
Vote for this answer ::

RE: What free/shareware software to use to work with MySQL files offline?
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/acc...
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Backup and Recovery

Interview Question :: What free/shareware software to use to work with MySQL files offline

Top Tags