Error On Importing Back-up Database
Jan 4, 2007
Quote:
Error
SQL query:
CREATE TABLE `hm2_deposits` (
`id` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`user_id` bigint( 20 ) NOT NULL default '0',
`type_id` bigint( 20 ) NOT NULL default '0',
`deposit_date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_pay_date` datetime NOT NULL default '0000-00-00 00:00:00',
`status` enum( 'on', 'off' ) default 'on',
`q_pays` bigint( 20 ) NOT NULL default '0',
`amount` double( 10, 5 ) NOT NULL default '0.00000',
`actual_amount` double( 10, 5 ) NOT NULL default '0.00000',
`ec` int( 11 ) NOT NULL default '0',
`compound` float( 10, 5 ) default '0.00000',
PRIMARY KEY ( `id` ) ,
KEY `hi1` ( `user_id` ) ,
KEY `hi2` ( `deposit_date` ) ,
KEY `hi3` ( `status` ) ,
KEY `hi4` ( `user_id` , `status` )
) ENGINE = MYISAM AUTO_INCREMENT =538 DEFAULT CHARSET = latin1;
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
View 5 Replies
ADVERTISEMENT
May 26, 2008
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
View 4 Replies
View Related
Feb 9, 2015
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?
View 2 Replies
View Related
Nov 5, 2014
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;
but it will not work...
View 2 Replies
View Related
Mar 20, 2014
I have Plesk Windows version, when I want import my backup mysql, i see below error:
Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...
View 7 Replies
View Related
Jun 28, 2007
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?
View 9 Replies
View Related
May 26, 2015
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.
View 1 Replies
View Related
Oct 24, 2008
I have a mysql database, and what I wanna do is to back up specific columns only. For example, I have a table with 2 columns:
City, Zipcode
How can I do that with mysqldump?
View 2 Replies
View Related
Jan 4, 2007
I have a site but it was corrupted due to server problem with host. I have a back-up of DB in phpMySQL.
I am now installing the same script in new server and the site is now running.
The problem is, I want to use my back-up database and replace the existing one. How to do this?
View 2 Replies
View Related
Oct 8, 2009
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
View 14 Replies
View Related
Jun 11, 2013
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.
View 19 Replies
View Related
Mar 15, 2013
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...
View 1 Replies
View Related
Jun 19, 2007
Can you put two of these supermicro mini servers back to back in a standard rack? I am looking at the [url]
View 14 Replies
View Related
Dec 20, 2007
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.
View 1 Replies
View Related
Aug 18, 2007
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.
Please try back in a few minutes
What can I do to troubleshoot this?
View 5 Replies
View Related
Apr 6, 2015
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
View 4 Replies
View Related
Feb 5, 2008
SQL query:
/*!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`
--
DRO' at line 1
View 8 Replies
View Related
Nov 10, 2009
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)?
View 14 Replies
View Related
Jun 12, 2007
how can I import a database dump from the Oracle Enterprise Manager 10g console? The Oracle is running on a Red Hat Linux Server.
View 0 Replies
View Related