Extracting MySQL Table

LindyTaylor · #1 (**permalink**) 02-09-11, 08:21

Hi

Recently I've purchased a website that is based on PHP and MySQL. The previous owner of the site doesn't have the SQL dump so I have to rebuild the MySQL database. Does anyone have an idea to export the MySQL tables form the web pages.

Irene9001 · #2 (**permalink**) 02-09-11, 08:22

You need to ask previous site owner about SQL dump. Anyway, it also depends on what form of access you have. Shell access and Admin control panel is the best option to figured out the issue. If the web site database is not so large then PHPMyAdmin would work well in this case, but if it is a large data base then you might have strength to grab the tables one by one.

LindyTaylor · #3 (**permalink**) 02-09-11, 08:23

I have a admin control panel access so its obvious I can access PHPMyADMIN and so forth, but the website's database is empty, however, everything is coded properly into the web site so I need to obtain everything from there.

Irene9001 · #4 (**permalink**) 02-09-11, 08:25

The structure of the database is supposed to be within the pages of the web site, except there is a SQL dump, but as you said there was not available. I think, unless the dump, you'd require to set everything from queries. You need the schema as well. That is a part of the dump of the master database.

Rozanne · #5 (**permalink**) 02-09-11, 08:26

As you need to regenerate the schema by testing of the code, then I'd suggest you to write one or more extracting programs to pull the data out of the HTML and set the database. I think you need to search old database backups of the site.