mysqldump alternative

Hi @artemis21,

We understand that you’re facing an issue that requires further investigation, and it may involve sharing log files containing sensitive information about your website. Unfortunately, such sharing is not allowed in www.remarpro.com forums for security reasons.

To ensure your privacy and get the necessary support, kindly contact us through the form on our Contact Us page, and we’ll be more than happy to assist you promptly:

https://duplicator.com/contact/?form=1

Looking forward to hearing back from you.

Thanks!

Hi,

I have found that my problem belongs to the size of the wp_postmeta table, in my case it’s over 300Mb, as my ecommerce has almost 20.000 products. Is there a way to filter WC products out of this table? or maybe it can be a suggestion for a feature in a future update?

Thank you

Hi?@artemis21,

Yes, you can filter out the wp_postmeta?table. This screenshot shows how to filter a database table from your backup: https://a.supportally.com/i/bJlB8O

I hope this helps.

Thanks!

Hello,
I’ve seen I can exclude the wp_postmeta entirely, but is there a way to filter out woocommerce products inside it? I don’t want to exclude ALL the posts (like blog for example).
In addition, why is the wp_postmeta table bold with a * ?

Thank you

Hi?@artemis21,

Unfortunately, Duplicator can’t exclude specific post types from your backups. However, this is on our roadmap to be implemented as a Pro feature.

In addition, why is the wp_postmeta table bold with a * ?
The wp_postmeta table is bold with a * becasue it’s a core WordPress table. It is highly recommended to not exclude WordPress core tables in red with an *, unless you know the impact.

I hope this helps.

Thanks!

Hi?@artemis21,

We haven’t heard back from you in about a few days, so I’m going to go ahead and close this topic for now. But if you’d like us to assist further, please feel welcome to continue the conversation (please just see my post above).

Thanks!

Hello,

I have activated shell_exec on the server for mysqldump but the plugin settings still shows that it’s not supported, how can I enable it?

Thanks

Hi?@artemis21,

Can you please provide me with a screenshot that shows the issue?

Hi, I don’t have a screenshot, my server just blocks some command by default that can be harmful.

This is the list, I removed shell_exec

getmyuid, passthru, leak, listen, diskfreespace, tmpfile, link, shell_exec, dl, exec, system, highlight_file, source, show_source, fpassthru, virtual, posix_ctermid, posix_getcwd, posix_getegid, posix_geteuid, posix_getgid, posix_getgrgid, posix_getgrnam, posix_getgroups, posix_getlogin, posix_getpgid, posix_getpgrp, posix_getpid, posix_getppid, posix_getpwuid, posix_getrlimit, posix_getsid, posix_getuid, posix_isatty, posix_kill, posix_mkfifo, posix_setegid, posix_seteuid, posix_setgid, posix_setpgid, posix_setsid, posix_setuid, posix_times, posix_ttyname, posix_uname, proc_open, proc_close, proc_nice, proc_terminate, escapeshellcmd, ini_alter,popen, pcntl_exec, socket_accept, socket_bind, socket_clear_error, socket_close, socket_connect, symlink,posix_geteuid, ini_alter, socket_listen, socket_create_listen, socket_read, socket_create_pair, stream_socket_server

Is there any other function I need to enable?

Hi @artemis21,

I reached out tot he development team about your questions and they replied that you need to enable these functions:
shell_exec, exec, proc_open and proc_close ,popen and pclose

Hi?@artemis21,

I’m closing this support topic for inactivity. Please don’t hesitate to contact us in a Support Topic if you need any help with Duplicator.

Thanks! 

Hello,
I have enabled shell_exec, exec, proc_open and proc_close, popen and pclose. But still the plugin shows that shell_exec is not supported. What can I do to check and enable mysqldump?

My problem is that the postmeta table is Rows: 2,401,151 with Size: 386.08MB. So the backup hangs at 22.5% If I exclude the postmeta table I can do the backup, but it’s useless. How can I avoid this issue?

Thanks

• This reply was modified 1 year, 1 month ago by artemis21.
• This reply was modified 1 year, 1 month ago by artemis21.

Hi?@artemis21,

We need to investigate this issue further. Can you pelase contact us through this form?
https://duplicator.com/contact/?form=1

Diagnosing this problem might require providing sensitive information about your system which is not allowed through this forum.

Kindly fill in the form with the issue details and we will do our best to help you.

Thanks!