Can I transfer database (products & phots, clients, sales history) from public to development site using ftp?
If you don't have SSH access to the site, you can create a database dump from the admin panel.
Navigate to System > Tools > Backups
Click "Database Backup" for database dump or "Database and Media Backup" for a database dump plus archive of catalog images. Confirm the dialog.
- Choose a file name, wait until backup is finished.
In your FTP client, navigate to
var/backupsand 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: