Support

Akeeba Backup for Joomla!

#38586 How to import split sql file to phpMyAdmin

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
3.10.11
PHP version
8.1
Akeeba Backup version
n/a

Latest post by nicholas on Sunday, 19 February 2023 14:39 CST

Sunday, 19 February 2023 06:31 CST

[email protected]

Hi I have a zip backup being generated to a GoogleDrive account from Akeeba backup Pro.

I unzip and open the sql dir

It contains 1 site.sql file plus a bunch of incremental files e.g site.S01 to site.S140

The original sql database size on the server is 71mb 

How do i import all these files into phpMyAdmin if i need to recover?

How can i read these .S01 files in Visual Studio or Atom?

Is there a way of splitting into e.g 4 X 20mb .sql files for example site1.sql , site2.sql, site3.sql, site4.sql which can be easily read and  uploaded individually in the event of needing a recovery?

Thanks

 

Edited by [email protected] on 2023-02-19 06:33 CST

Sunday, 19 February 2023 14:39 CST

nicholas

Do remember that if you choose the “All configured databases” you get a backup archive WHICH INCLUDES THE INSTALLER. You do NOT have to manually restore these files. You are expected to use the installer. You just restore it just like any other Akeeba Backup backup archive, using Kickstart — including clicking on Run the Installer after extracting the archive which does indeed launch the restoration script which was included in the backup archive.

Alternatively, you can follow the manual instructions outlined in Unorthodox: the emergency restoration procedure but it's a very laborious process.

If you really want to restore SQL files through phpMyAdmin instead of using a web-based installer script you should instead use the “Main site database only” backup type. This creates a flat .sql file which can be imported into phpMyAdmin using its aptly named Import feature. Kindly be advised that this is strongly advised against for database over 20MiB as phpMyAdmin is very likely to time out. That's why the “All configured databases” includes the same installer script (ANGIE) as the full site backup; it's designed to be resilient to server timeouts even with supermassive databases spanning several GiB in size on dead slow servers.

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 Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!