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

Importing Big Database

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

Plesk 12.x / Linux :: Importing Large Database To Phpmyadmin?

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

Plesk 11.x / Linux :: Importing To MySQL Database - Maximum Execution Time

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

Plesk 11.x / Windows :: Importing MySQL Backup - Unable To Restore Database

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

GoDaddy - Importing A 1MB Db To Mysql Gives Error

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

Plesk 12.x / Linux :: Error 505 Bad Gateway - When Importing SQL Dump Via PHPMyAdmin

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

How To Back Up Columns In Mysql Database

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

Back-up Database And Replace The Existing One

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

Mails Bouncing Back With Error Number 450

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

Plesk 11.x / Linux :: Failed To Pack Files Back - Backup Error

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

Apache :: Database Error On All Non-database Webpages

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

Supermico Minis Back To Back

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

Importing Large Mysql DB In Shell

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

Database Error

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

Plesk 12.x / Linux :: Importing Large Sql File Via SSH

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

Getting Error While Restoring Database.

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

Does Your Provider Back Up Your VPS Or Do You Back It Up Yourself

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

Importing Data From Oracle Enterprise Manager Console

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







Copyrights 2005-15 www.BigResource.com, All rights reserved