• From: USA, Michigan
  • Registered: 01/26/2024
  • Posts: 6

Topic: Backup / Restore data to a new database

Hello,

I've been having issues with my hosting company so I finally installed FrontAccounting locally. 

I'm trying to backup and resotre the data from my hosting company database to my local instance.

I know it's not as easy as using the back/restore function in FrontAccount and making a backup on the hosting database and then restoring to my location instance.  (as I tried that many times in the past)

So is there a guide or does someone have the steps to do this.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,227

Re: Backup / Restore data to a new database

Just take a backup of your web installation folder of FA for the remote host. I trust you will be doing a windows based local hosting on your desktop. If not suitably modify accordingly.
Match the PHP / MySQL and the respective ini file values to your local environment.
Unpack the web remote web folder backup into your local web setup.
Take a full FA MySQL backup from within the FA remote installation (if data is limited) or a phpmyadmin backup if otherwise.
Then restore them to the local web server re-creating the MySQL databases along with their collation and content.
Make any changes to your FA config.php file in your local install as appropriate.
You should be good to go.

apmuthu's Website