Guest Perileos

Reconstructing databases

Recommended Posts

Guest Perileos

Hi.

 

If you've ever downloaded a big .sql file and are wondering how to reconstruct them to extract and read the data easier, this is the thread.

First we need to download Xampp, xampp is a program that let's your make a local server. So you could run a database on your computer and get it to work with the websites you're building.

 

When we have done that, open your control panel run the first two options called "Apache" and "MySQL".

 

Open your browser and browse to localhost and then you should stop Apache and MySQL from the control panel and read this guide on how to increase upload capacity in your phpmyadmin:

https://stackoverflow.com/questions/3958615/import-file-size-limit-in-phpmyadmin

 

Once you've done that, browse to localhost/phpmyadmin and create a new DB with your desired name and then head to import and load your file.

 

When upload is done, browse through your DB and search for the desired table/column or whatever you wanna read and export accordingly.

Share this post


Link to post
Share on other sites
Guest

This is a bump

Share this post


Link to post
Share on other sites
Guest

This is a bump

Share this post


Link to post
Share on other sites
Guest

This is a bump

Share this post


Link to post
Share on other sites
Guest

This is a bump

Share this post


Link to post
Share on other sites
Guest

This is a bump

Share this post


Link to post
Share on other sites
Guest

This is a bump

Share this post


Link to post
Share on other sites
Guest

This is a bump

Share this post


Link to post
Share on other sites
Guest

This is a bump

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.