mysqldump alternative

Resolved artemis21
(@artemis21)

2 years, 4 months ago

Hello,

my website package gets stuck at 22.3 during building, I troubleshot the problem in local server and found that it can complete the build if I enable mysqldump. However my remote server does not support shell_exec and it does not have mysqldump. What is the reason PHP code does not work while mysqldump does? My server uses PHP 7.4.33

PHP max input var 5000

PHP time limit 300

PHP memory limit 2048M

Max input time 60

The whole website is about 450Mb

Thank you

Viewing 13 replies - 1 through 13 (of 13 total)

Plugin Support mohammedeisa
(@mohammedeisa)

2 years, 4 months ago

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 ww.wp.xz.cn 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!

Thread Starter artemis21
(@artemis21)

2 years, 4 months ago

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

Plugin Support mohammedeisa
(@mohammedeisa)

2 years, 4 months ago

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!

Thread Starter artemis21
(@artemis21)

2 years, 4 months ago

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

Plugin Support mohammedeisa
(@mohammedeisa)

2 years, 4 months ago

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!

Plugin Support mohammedeisa
(@mohammedeisa)

2 years, 4 months ago

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!

Thread Starter artemis21
(@artemis21)

2 years, 3 months ago

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

Plugin Support mohammedeisa
(@mohammedeisa)

2 years, 3 months ago

Hi @artemis21,

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

Thread Starter artemis21
(@artemis21)

2 years, 3 months ago

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?

Plugin Support mohammedeisa
(@mohammedeisa)

2 years, 3 months ago

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

Plugin Support mohammedeisa
(@mohammedeisa)

2 years, 3 months ago

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!
Thread Starter artemis21
(@artemis21)

2 years, 3 months ago
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 2 years, 3 months ago by artemis21.
- This reply was modified 2 years, 3 months ago by artemis21.
Plugin Support mohammedeisa
(@mohammedeisa)

2 years, 3 months ago

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!

Viewing 13 replies - 1 through 13 (of 13 total)

The topic ‘mysqldump alternative’ is closed to new replies.