Can I transfer database (products & phots, clients, sales history) from public to development site using ftp?

  • 1
    why not? dump your database and copy it over
    – MagenX
    Nov 23, 2015 at 16:19
  • 4
    I'm voting to close this question as off-topic because this is about databases and file transfer.
    – 7ochem
    Nov 23, 2015 at 18:37

1 Answer 1


If you don't have SSH access to the site, you can create a database dump from the admin panel.

  1. Navigate to System > Tools > Backups


  2. Click "Database Backup" for database dump or "Database and Media Backup" for a database dump plus archive of catalog images. Confirm the dialog.


  3. Choose a file name, wait until backup is finished.
  4. In your FTP client, navigate to var/backups and download the created backup archive. You can also try to download the file directly from the admin grid instead of using FTP. To do so, click on the "gz" link:


Not the answer you're looking for? Browse other questions tagged or ask your own question.