Exporting files from database
-
I have a plugin for WordPress that is using about 20GB of space. The plugin saves form data from the workers in the field. Natively I can delete the 3 years of old data, but there is no way in the WP admin to export or backup the data before deletion.
If you use phpmyadmin to export data, that data is still on there server correct? I want to use the export to csv for Excel to backup the data before deletion.
-
@technobabble said:
I have a plugin for WordPress that is using about 20GB of space. The plugin saves form data from the workers in the field. Natively I can delete the 3 years of old data, but there is no way in the WP admin to export or backup the data before deletion.
If you use phpmyadmin to export data, that data is still on there server correct? I want to use the export to csv for Excel to backup the data before deletion.
I'm pulling up my site so I can get into the myPHPadmin console and look at my DB... There is an option when you export the DB that should allow it to be saved server side. But I don't recall. Let me get into the system and confirm or deny that - .. I've exported DBs in the past when I was moving my Joomla! site from one host to another... pretty much the same process..
-
@technobabble Here is a screen shot of the export ability. You can save to the local server
Your format list could be slightly different due to host differences, but you can export to SQL, CVS or CVS for Excel.
Does that help any?
-
Exports do not delete data.
-
@scottalanmiller Thanks...I didn't think so, but with this client, I had to be 100% sure.
-
@g.jacobse Thanks bud, I knew I could do that. Now that my head is clearer this morning, I remembered that I have done exports before without any issues to existing data.
-
Since moving websites to WP and becoming mostly a WP shop, I haven't had to touch databases or export except for backups (weekly) and moving sites from one host to another which only happens when I move a client to my hosting.
-
@technobabble said:
@scottalanmiller Thanks...I didn't think so, but with this client, I had to be 100% sure.
Most tools, like WordPress as an example, do an export for every backup operation.
