MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 18
I currently own a gaming website, and it's database has about 70mb.
I'm changing to a VPS, so today i put the site under maintenance, uploaded the files to the new server, changed the DNS of the domain, and when i was uploading the database (Using PhpMyAdmin), everything looked fine until after like 1:20 hs, the window changed from the "uploading" status to the login page of plesk.
So i though "It must've finished"... but no, i logged in, and the database was empty, so apparently it didn't work.
Maybe because my internet connection isn't very good (640k) and a timeout occured?, idon't know.. but the thing is,
Is there a different way to upload the database that it isn't phpmyadmin?, or using it but uploading by small pieces, so this doesn't happen again... something like that.
I'd really appreciate different options, and as soon as possible, since i don't want to have my website offline for so long
I'm on a VPS with Ubuntu 14.04 and Plesk 12 Web Admin Edition. I can't import a large (20 MB zipped) database dump to phpmyadmin because there is a 2MB file size limit. I suppose I have to change the server-wide PHP configuration (if I change the PHP settings for the domain nothing happens). Is there a way to change the global PHP settings via the Plesk panel?
I have this error when i put import to mysql database
Code: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<script></script><p>ERROR: Maximum execution time of 300 seconds exceeded (Util.' at line 244
I have in domain > doemainname > max_execution_time Standaard Geef een aangepaste waarde op 0
and insert in usr/local/psa/admin/htdocs/domains/databases/phpmyadmin in the file config.sample.inc.php following command $cfg['ExecTimeLimit'] = 70000;
I've been trying to import a 1MB sql file into mysql under GoDaddy Linux Deluxe shared hosting and after waiting forever I get a 2006 error -server has gone away. didn't know that 1MB was such a big file!! anyone else experiencing the same?
under Plesk 12.0.18 PHPMyAdmin is failing to import a 3 MB SQL dump of a simple Joomla website. "Error 505 Bad Gateway", it says.It happens with other dumps too, some as small as ~500 KB. The format (SQL or ZIP) of the file uploaded doesn't seem to matter, because the upload itself seems to work; it seems it's the post-processing what is raising the error.
The funny thing is that the import itself seems to work (the contents of the SQL dump are imported), but the error message appears and causes confusion and support requests from our clients./var/log/sw-cp-server/error_log says:
2015/05/15 03:19:31 [error] 10215#0: *5 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: XX.XX. XXX. XXX, server: , request: "POST /domains/databases/phpMyAdmin/import.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "xxxx. xxxxxxx.com:8443", referrer: URL.....To me it sounds like a timeout.
This seems to be a "popular" error among Plesk users, and I have tried this, this and this with no luck.
I am facing a problem with my mails. I have hosted a new domain on my server and that domain is getting a lot of bounce messages with the following error message:
Message is waiting at <Mail server name> for delivery to <recipients SMTP>.
Message delivery has been delayed to the following recipients: Recipient: [SMTP:<recepients email id>] Reason: Remote SMTP Server Returned: 450 <Senders email id>: Sender address rejected: Domain not found
Also when I try to check the DNS settings of that domain from network-tools.com I get the error message as:
Retrieving DNS records for <domain name>...
DNS servers nameserver1 [xxx.xxx.xxx.xxx] nameserver2 [xxx.xxx.xxx.xxx] Query for DNS records for <Domian name> failed: Timed out
The hosting server is configured on the following softwares: Plesk 8.4 control panel Bind DNS Mail Enable Mail server
Since Microupdate 11.0.9 #52/#53 I get the following error from my scheduled backup:
<description>Failed to pack files back__domainname_mn_1306110314 in /var/lib/psa/dumps/xy/clients/xy/domains/domainname [ 945838637056 bytes free of 980876906496 bytes total on mount point 0]</description>
Some related problems have already been discussed here in the forum (e.g.: [URL] .... or this one: [URL] ...., but it all did not quite match with my problem.
I've just built a new LAMP server and I'm having a little issue where Apache doesn't serve a simple non-database webpage, instead, I get an error on all my virtual-host in the browser: Database Error: Unable to connect to the Database: Could not connect to MySQL.
I've googled the problem but since the error mentions MySql, everything I find is related to connecting to MySql, which I'm not trying to connect... and I've contacted my Linux mentor about this issue... This is something I've never seen before... don't know why Apache thinks I'm trying connect to MySQL on every browser call to the server...
However, MySQL is accessible via telnet, and all my permissions are correct...
if there was a way for me to cut up a large mysql database in shell. We're talking almost 8 gigs here.
I would like to import it in chucks, something like 1 gig per shot. Is that doable with some software that I can use in shell? I wouldn't want to use vim to splice up that sucker.
Or is there a better method of doing this? I already dumped this and I rather not do it again unless if I could perhaps dump this in chunks.
I have a client who moved a site from one linux server to another. This site uses a script with members. The script worked fine on the old server, but on the new one, when members try to update their information, they get this error:
Exchange process unavailable at this time because of database is conducting scheduled task.
I have been trying quite unsuccessfully to import a large sql db file via phpMyAdmin for one of my clients. Since the db file is about 250mb I get a server timeout error.how I can do this via SSH...I have a CentOS server 6.5, 64 bit that runs Plesk v 12.0.18
/*!40000 ALTER TABLE `qhvbmailer_attachments` DISABLE KEYS */;
MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; UNLOCK TABLES;
-- -- Table structure for table `qhvbmailer_campaigns` --
Many of the VPS providers I've looked at don't back up the servers that house the VPSs and as such don't back up the VPSs either - have you considered what would happen should the VPS itself be erased (such as what happened to vaserv/fsckvps not too long ago)?