Akeeba Backup for Joomla!

#8919 extract sql database out of jpa file manually

Posted in ‘Akeeba Backup for Joomla! 4 & 5’

This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version

n/a

PHP version

n/a

Akeeba Backup version

n/a

Latest post by nicholas on Monday, 11 July 2011 07:48 CDT

Sunday, 10 July 2011 20:53 CDT

roll82

Hi, is it possible to manually extract the mysql database with the
akeeba extract wizard out of the .jpa file?

Sunday, 10 July 2011 23:25 CDT

rkendallc

The akeeba extract wizard is able to be used for exactly that. You can extract any files or the sql files out of it. I believe the SQL itself is stored in the installation directory once you extract it locally. You should be able to search the directories for a dot-sql file (.sql) within the extracted folders to find the exact location.

Download the extract wizard from the downloads area of the website.

Monday, 11 July 2011 02:40 CDT

roll82

Thanks for your quick reply. I found the installation folder but there are a couple of database files. when i try to open the joomla.sql it is just a part of the complete database. how would i get them all together to a full one.

these are the files i have there:
joomla.sql, joomla.s09, joomla.s08, joomla.s07, joomla.s06, joomla.s05, joomla.s04, joomla.s03, joomla.s02, joomla.s01, databases.ini

Thanks

Monday, 11 July 2011 07:48 CDT

nicholas

All of those files (except the databases.ini) contain parts of the database dump. I had written a step-by-step tutorial for manually restoring a site. If you follow steps 2, 3 and 4 of that tutorial you can achieve exactly what you want.

It goes without saying, if you get stuck anywhere, ping me and I'll try to help you as best as I can!

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support