Support

Akeeba Backup for Joomla!

#9026 How to transfer the Data Base only to another Site

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 Friday, 26 August 2011 05:17 CDT

user19306
Nicholas,
1) Can you refer me to a link giving instructions on how to Transfer the Data Base Only from our UK .co.uk Site to our US site. ie .com

WE are adding Products to the UK site and would like a simple convenient upload process that could be done at the end of a day?

2) Presumably the Transfer Wizard would transfer the whole Site to a new address. Is this used if you decide to change hosts?

nicholas
Akeeba Staff
Manager
Hi Mike,

1. Uh, that's a good idea. I never wrote such instructions, but I can think of two ways right away.

Method I (easy): Create a new backup profile. Using the Files and Directories Exclusion exclude all directories and files on your site's root. If you only want to transfer specific tables (and not everything) you can also use the Exclude Database Tables to exclude the tables you do not want to transfer. Now, take a new backup. What happens is that the backup archive contains only your database (except those you excluded) and the installer script. Nothing else. Use Kickstart to restore it on the .com site and you're done. Only the database is updated, not your site's files.

Method II (complicated): You can create a new profile and set it to database only. Click on the Configure button next to the Database Dump Engine and set the "Size for split SQL dump files" to 0. Then, take a new backup. Instead of an archive you get a SQL file. You can restore that file using phpMyAdmin on your .com site.

2. Yes, the Transfer Wizard does transfer the whole site to a new server. Yes, it can be used when you change hosts. However, depending on host settings, it may not work for some sites. In this case, the solution is trivial. Backup the site you want to transfer. Restore it -using Kickstart- to the new server. Done :)

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!