Facebook
Twitter
-
If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
CentOS2Alma discussion -
Inviting everyone to the UX test of a new security feature in the WP Toolkit
For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.
What format is the database file in, plain sql or some compressed archive, such as zip or tar.gz?
How are you uploading the file, are you using FTP or SFTP or perhaps the Plesk interface..?
Basically, compress the file if it isn't already compressed and use FTP or SFTP.
How are you uploading the file, are you using FTP or SFTP or perhaps the Plesk interface..?
Basically, compress the file if it isn't already compressed and use FTP or SFTP.
An upload limit implies that you are trying to upload that large file through the GUI. This will not work. Even if you increase the upload file size limit you will hit the script runtime limit. Instead, please use an FTP client such as Filezilla to upload the file manually through FTP. This will always work.
After you have managed to upload it (e.g. by FTP) you might get into trouble importing it. Most likely the process will be interrupted, because it will exceed the maximum allowed script runtime. Instead, you will need to import the file step by step. For the process I can only recommend Ozerov's "BigDump" importer.
BigDump: Staggered MySQL Dump Importer
It imports n lines, then closes and restarts itself, imports the next n lines and so on until the whole file is processed. By this loop the script runtime always stays short, so that an import will succeed even on systems with little resources and tight limits.
After you have managed to upload it (e.g. by FTP) you might get into trouble importing it. Most likely the process will be interrupted, because it will exceed the maximum allowed script runtime. Instead, you will need to import the file step by step. For the process I can only recommend Ozerov's "BigDump" importer.
BigDump: Staggered MySQL Dump Importer
It imports n lines, then closes and restarts itself, imports the next n lines and so on until the whole file is processed. By this loop the script runtime always stays short, so that an import will succeed even on systems with little resources and tight limits.
Last edited:
Thank you Peter. Unfortunately, I can't get it done. I believe my knowledge is not large enough. I got a Ionos Cloudserver with Plesk. When I import I get this error:
Unable to import the hicker_db dump:
ERROR at line 3949116: Unknown command '\a'.
Traceback (most recent call last):
File "/opt/psa/admin/sbin/dbbackup", line 6, in <module>
File "/opt/psa/lib/modules/python/dbbackup/dbbackup.py", line 99, in main
restore(options, password)
File "/opt/psa/lib/modules/python/dbbackup/dbbackup.py", line 88, in restore
raise Exception("program 'mysql' finished with non-zero exit code: %d" % p.returncode)
Exception: program 'mysql' finished with non-zero exit code: 1
I wonder if here is somebody I might be able to hire to help me importing this file? or helping me with your suggestion?
Unable to import the hicker_db dump:
ERROR at line 3949116: Unknown command '\a'.
Traceback (most recent call last):
File "/opt/psa/admin/sbin/dbbackup", line 6, in <module>
File "/opt/psa/lib/modules/python/dbbackup/dbbackup.py", line 99, in main
restore(options, password)
File "/opt/psa/lib/modules/python/dbbackup/dbbackup.py", line 88, in restore
raise Exception("program 'mysql' finished with non-zero exit code: %d" % p.returncode)
Exception: program 'mysql' finished with non-zero exit code: 1
I wonder if here is somebody I might be able to hire to help me importing this file? or helping me with your suggestion?
