How to open .sql backup of my forum?
January 21st, 2020
Thanks!
Here is a preview database software…
http://www.digitalcoding.com/free-software/database/SQL-Preview-and-Export-Tool.html
Other then that, you have to say install the software, and host it on your comp to view (unless you find other similar software..)..
Personally id view and export to either excel or access..
Thanks! But how do I add the actual backup file into this software?
If you don’t know programming http://www.gfi.com/blog/top-10-free-database-tools-for-sys-admins/
Its not really programming, its just finding the info you need to let the prog open the database. That is Data provider, there is a list of them on the linked page (One of 10 or so, if you dont know try each one…). SQL statement, name of database and fields you wanna view heres an example:
http://www.w3schools.com/sql/sql_select.asp
As well as Database Connection String. There is multiple ways to get the string, just google it and try one of the given examples.
Its not really programming, .
There are two ways to access a SQL database: by using a software like the ones I linked(and not only) and by programming.
Or just install Wampserver and import the database into the mysql instance. You can import and look through it all with phpmyadmin.