Find Jobs
Hire Freelancers

In new server Centos 7 + Plesk Onyx when we import a database we get en error. Propably need to increase the value of Edit /etc/my.cnf file and increase the values of the innodb_log_buffer_size and innodb_log_file_size under

$10-15 USD

Closed
Posted over 6 years ago

$10-15 USD

Paid on delivery
In new server Centos 7 + Plesk Onyx when we import a database we get en error. Propably need to increase the value of Edit /etc/[login to view URL] file and increase the values of the innodb_log_buffer_size and innodb_log_file_size under [mysqld] section, for instance: [mysqld] innodb_log_file_size = 500M innodb_log_buffer_size = 800M the error is the follow Unable to import the eshopsgr_mag21 dump: ERROR 1293 (HY000) at line 84: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause Traceback (most recent call last): File "/usr/local/psa/admin/sbin/dbbackup", line 6, in <module> File "/usr/local/psa/lib/modules/python/dbbackup/[login to view URL]", line 99, in main restore(options, password) File "/usr/local/psa/lib/modules/python/dbbackup/[login to view URL]", line 88, in restore raise Exception("program 'mysql' finished with non-zero exit code: %d" % [login to view URL]) Exception: program 'mysql' finished with non-zero exit code: 1 Needfull written instarctions how to correct the issue in other servers too
Project ID: 15018158

About the project

17 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
17 freelancers are bidding on average $25 USD for this job
User Avatar
This error is because the plesk server is using older vesion of MySQL than your source MySQL server. You need to upgrade MySQL on your plesk server. I can do this if you have root SSH access.
$20 USD in 10 days
5.0 (1054 reviews)
7.6
7.6
User Avatar
A proposal has not yet been provided
$40 USD in 1 day
5.0 (479 reviews)
7.4
7.4
User Avatar
Hello. I would like to help you with updating Mariadb to latest version. I have experience. Please read my feedbacks. Thank you.
$20 USD in 1 day
4.9 (989 reviews)
7.6
7.6
User Avatar
Hi, I will fix this issue and make server live. I will fix import database error and make sure it will not occur again. Thank you
$30 USD in 1 day
4.9 (419 reviews)
7.1
7.1
User Avatar
Hi there, I have read what you exactly need, however I would like to ask you a few questions Please feel free to ping me anytime so we can have a detailed discussion and finalize our budget and timeline.
$19 USD in 1 day
5.0 (105 reviews)
6.6
6.6
User Avatar
Hello, I will audit your server to find exact issue and will resolve all server issues. I have more than 3 years experience as a Linux admin. Thank you
$30 USD in 1 day
5.0 (141 reviews)
6.2
6.2
User Avatar
Dear Project Owner, I am Red Hat Certified Linux Engineer and having 5+ year of experience in Managing Core Server | Dedicated Server | VPS Server | Server Security | Server Optimization | Backup and Restoration process | Complete Server Setup and Management. Keeping it very simple and significant, I have read out your job description clearly and I can do this job. My Expertise: WHM/cPanel Management | Virtualmin | Plesk Panel| Core Server Management | Amazon Web Services | PowerMTA | MySQL | PHP | Apache | SQL | IIS | DNS Management | Exim | Postfix | Send Mail | FTP | SMTP configuration and Mail Server Setup|Server Monitoring | Backup Management | Backup Recovery & Server Migration | SSL Certificates and installation | DDOS Protection | NGINX | Firewall Configuration. I will provide you live chat support as well so less communication gap will provide good results. As I am looking for new work associations, so I am ready to start the work in minimum cost with best quality of results. I request you to start the conversation once, so you can have faith on my skills. Looking forward to hear back from you!! Thank You!!
$25 USD in 1 day
4.9 (31 reviews)
4.9
4.9
User Avatar
having 15 years experience in manage webhosting servers with plesk and cpanel. Kindly PM with me for details and start work. I will fix this issue. waiting for you in PM session
$17 USD in 0 day
5.0 (13 reviews)
3.6
3.6
User Avatar
Hello, I have read your project REQUIREMENT. We deal with the ALL TYPE OF SERVER RELATED ISSUE as we have expert team for this. We will be able to do but we need proper details regarding your projects. We are the leading IT Company in Indore, India. We have huge experience and mastery in app development, app designing and developing backend, cloud services, and enterprise solutions. We are a team of certified Amazon solution architects. We are also part of Amazon APN partner network. We do provide all kinds of solution related to Network administration or for system admin, Linux, Unix, Apache, servers, lambda EC2, Open SSL. We can provide you solution for all your customized needs. Please check our recent works:- Need AWS Setup for an ASP.NET Application AWS | EC2 | RDS | BEANSTALK | CLOUD FORMATION https://www.freelancer.in/projects/Amazon-Web-Services/Need-AWS-Setup-for-ASP/ https://www.freelancer.com/projects/Amazon-Web-Services/Lambda-setup-push-cloudwatch-logs/ https://www.freelancer.com/projects/Cloud-Computing/Setup-New-Azure-Cloud/ https://www.freelancer.com/projects/Amazon-Web-Services/Push-AWS-RDS-psql-bucket/ https://www.freelancer.com/projects/Linux/FIX-OPENVPN-IPTABLES-CENTOS/ https://www.freelancer.com/projects/nodejs/code-deployment-heroku-AWS/ https://www.freelancer.in/projects/Amazon-Web-Services/Need-AWS-Setup-for-ASP/ I am sure above example will provide you the quality of work. Thanks and Regards Sumit
$25 USD in 10 days
4.9 (10 reviews)
3.3
3.3
User Avatar
6+ years experience in Linux Server Administration, extensive experience in installing, configuring: APF or CSF Firewall Apache & MySQL optimization MySQL optimization Database issues, backup and repair DNS configuration issues Load balancing PHP configuration, upgrades, and site errors Security lock down Disaster recovery Seamless Server migrations Proactive Server Monitoring Guaranteed Uptime
$20 USD in 10 days
5.0 (4 reviews)
2.9
2.9
User Avatar
I've read your requirements in detail and I can able to do the project development with your full satisfaction + projected Delieverables.
$30 USD in 0 day
4.9 (2 reviews)
1.9
1.9
User Avatar
Hello I will fix this issue with MySQL Also will tell you where is the problem Regards Igor Chaban PHP developer, Linux system administrator
$25 USD in 0 day
5.0 (5 reviews)
2.0
2.0
User Avatar
if you are trying to define more than one MySQL TIMESTAMP fields using CURRENT_TIMESTAMP or "default now". I can fix this issue. Kindly drop a message so we can discuss.
$17 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've been working with Databases since 1984: including mySQL, data analysis, modeling, migration, conversion, integration, aggregation, mining, optimization, performance tuning, warehousing, etc. Since it is difficult to determine the scope of the project from the current description, my price is only general. Once we determine the cause and cure, I'm sure we can come to a mutually agreed upon price or hourly rate. Could you send me the table structures of what you are trying to import: The actual SQL statement that created the tables. Especially ones with two timestamp columns. Also, what version is the database that you exported? What version is the database you are importing into?
$17 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GREECE
Chania Crete, Greece
5.0
305
Payment method verified
Member since Dec 20, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.