Unable to Export on WordPress.com Hosted Website

Hi Steve,

There are some export issues with FireFox and Internet Explorer. Google Chrome should work. Does this help to solve your issue?

BTW, the issues with FireFox and Internet Explorer are solved in the next release which I hope to deploy this week(end)…

Best regards,
Peter

Hi Peter.
From the Table list –> Manage –> Export option, it downloads something in both Safari for Mac and Chrome. However, the tiny file only have the below.

I have a wordpress.com hosted site, so do have restricted access to backend server stuff.

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES latin1 */;

—
— Table vp_backup_wp_xxxx_postmeta not found
—

—
— No rows to export from empty table vp_backup_wp_xxxx_postmeta
—

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Hi Steve,

Normally you should het this message when the table is empty. Does the table contain any records?

Have you tried to export the table from Data Explorer main page?

Best regards,
Peter

Hey Peter,
It does not matter which file I select Manage—>Export, it returns this empty text file. Even with tables with a little data or the big boys such as _posts or _postmeta.

When I click explore, I’ve just realised that I can select all on that page view (50 rows) and export that. That works. But as I wish to pull down tables with 4000+ lines, that’s not going to work. When I change screen options to show 999 lines, it looks like the script is too long and times out – returning no file whatsoever.

Any further info you need?

Kind Regards,

STEVE KATASI

P.S. I have some restore issues with website, which WordPress.com are looking into. They messaged the below, just FYI:

“POOR PERFORMANCE

While debugging the Pages list problem, we also discovered that the WP Data Access plugin is adding approximately 0.712 seconds of database queries to every wp-admin pageload, making that whole area slower than it needs to be.

So we would strongly recommend deactivating that plugin when not actively using it for data access.”

Hi Steve,

Thanks or all the input. I have tested exporting tables up to 100.000 records on Linux and Windows. I never tested the plugin on a Mac. I’ll leave this topic open and see i can borrow a Mac for further investigation.

Have you tried the Data Backup tool? You can use it from the plugin menu. It writes the export file to a backup medium without browser intervention. Maybe that works…?

Thanks or sharing the poor performance issue! I have to optimize the security checks. I’ll put that subject with high priority on my to do list.

Best regards,
Peter

Thanks Peter.

I haven’t. Is not the same as the auto-backup that Jetpack provide?

Cheers,
Steve

Hi Steve,

You can use the Data Backup tool to create export files at regular intervals and write them to your local file system or your Dropbox. The Data Backup tool uses the same code as the table and row exports but without a browser. You might be able to export your large table with the Data Backup tool.

Thanks again for pointing out the performance issue. I wasn’t aware of it. Been working all night on this issue, found a design mistake and was able to optimize some code. ?? It will be better in the next release and I’ll continue to improve it later.

Best regards,
Peter

Cool, I might give the data backup tool a go. Are you able to run it as a one off as opposed to regularly?

Nice one on performance issue. ????

Hi Steve,

At this time you have to define an interval for a data backup. But I added your suggestion to my to do list. ??

I continued working on the performance issue. I have been focusing so much on security that I forgot about performance. In the next release all security checks are delayed so that checks are only performed when really needed. The results are amazing! ?? Thank you so much for sharing this information!

Best regards,
Peter

That would be great Peter.
I’ve got regular backups performed by Jetpack / WordPress.com, however it turns out that they’ve got a bug in the process. I learnt the hard way last week when I went to restore from a backup. It was a mess.

They will (are) fix the issue, but I’d like to pull tables out at my choosing to check a few things, and do adhoc local backups independent of their backup process.

I assume your backup process pulls a direct copy of the live instances of any selected table? WP create a backup table and have that maintained and backup up by the looks of things. prob a perforce thing as it’s generic and automatic for all clients.

If you could enable adhoc non-browser backups of a selected table(s) that would be perfect.

Regarding the performance thing, that’s great to hear! Glad my mini-disaster has some silver lining. ??

Best,
Steve

Hi Steve,

Just wanted to inform you that version 2.0.10 is out. With support for adhoc non-browser backups of selected tables! ??

Have a nice weekend!

Best regards,
Peter

Wow – that was quick!

Cool, will check it out early next week and let you know.

Thank you! S

Hey Peter.

Just quick one.

I authorised to Dropbox and kicked off a one time adhoc backup fo a couple tables.

It suggested that the backup had started and to check the backup location. No folders and files created.

When I went into DataBackups in WP Data Access, you could see the backup job. When I clicked into ‘info’, there was a message saying ‘ERROR: Invalid table name or not authorized’.

See screenshots below.

https://www.dropbox.com/sh/cu9sbk3hhc1ukyb/AAAnWD1WqaAOltGPPFD4iIeNa?dl=0

Have you testing the plugin backup and export functionality on a wordless.com hosted site? Of course, in this setup WordPress have admin control over the server and associated WP install, including the database.

Would it be that WordPress.com simply restrict the access the plugin grants?

Thanks,
Steve

Hi Steve,

I have not tested the plugin on WordPress.com. I don’t know if there are any database access restrictions, but I’ll investigate the issue.

Just to be sure… Can please you check your table access?

This is how: In the plugin navigate to “Manage Plugin”. Below tab “Back-end Settings” enable “Show WordPress tables”, “Allow viewing structures” and “Allow access to other schemas”. From the plugin point of view you then have access to all the tables in your WordPress schema.

Best regards,
Peter

Are these tables located in the WordPress database schema Steve? Or do you have to change the schema in the Data Explorer first?

Best regards,
Peter