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
ADVERTISEMENT
Aug 21, 2008
i always get :-
Fatal error: Maximum execution time of 30 seconds exceeded in /home/ante/public_html/me/classes/http.php on line 418
Warning: fclose(): supplied argument is not a valid stream resource in /home/ante/public_html/me/classes/other.php on line 145
when i try upload big files (up 140mb to my vps using RapidLeech
and here my php.ini
[url]
i chnaged the php.ini to the new value and restart http only
my vps info
safe mod : on
Operating system: Linux
PHP version: 5.2.5
Apache version: 1.3.41 (Unix)
View 4 Replies
View Related
Feb 5, 2007
while i am restoring db (110MB) via SSH following error occur
Code:
ERROR 1064 (42000) at line 145689: 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 '
Fatal error: Maximum execution time of 30 seconds exceeded in ' at line 1
View 12 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
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
May 27, 2009
I am trying to run a php script on our server to split a very large file. As a result of the file size the script is timing out with this error:
Fatal error: Maximum execution time of 30 seconds exceeded in [url]on line 155
How can I extend the server execution time to the script can complete? I have cpanel with WHM installed.
View 8 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 21, 2008
During the last couple of weeks my main server has started acting weird.
Sometimes(often) when accessing my site, I get a page saying that server or location could not be found. Reload and "bam" page loads again. Average load on the server is 0.50
When executing scripts (I.E uploading files using web2ftp or cp file manager) server shuts the connection after a few seconds and say page cannot be found.
I set the execution time in php to 60sec, so this is not the issue.
When I ping the server, I do not get any packet losses.
View 4 Replies
View Related
Dec 18, 2014
Currently i am using webalizer... How can i switch to aw stats by importing the current data...
View 1 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 7, 2014
Have the same case for 4 servers (web and pro), the menu in plesk could not show another choice, only fastcgi.
Handlers look like ok:
root@serveur:~# /usr/local/psa/admin/sbin/php_handlers_control --list
id: display name: version: type: cgi-bin: cli-bin: php.ini:
module 5.4.4 5.4.4 module /usr/bin/php5-cgi /etc/php5/cgi/php.ini
fastcgi 5.4.4 5.4.4 fastcgi /usr/bin/php5-cgi /etc/php5/cgi/php.ini
cgi 5.4.4 5.4.4 cgi /usr/bin/php5-cgi /etc/php5/cgi/php.ini
[code]....
How to force to display php module ?
View 3 Replies
View Related
Apr 13, 2015
while plesk was trying to update automatically (as per the normal preference settings) but suddenly gave this error
Execution failed.
Command: autoinstaller
Arguments: Array
(
[0] => --select-product-id
[1] => plesk
[2] => --select-release-current
[3] => --upgrade-installed-components
)
Details: Doing restart of Parallels Installer...
File downloading products.inf3: 100% was finished.
File downloading plesk.inf3: 10%..20%..30%..40%..50%..60%..70%..80%..90%..100% was finished.
File downloading ppsmbe.inf3: 17%..26%..37%..47%..57%..78%..88%..100% was finished.
File downloading sitebuilder.inf3: 22%..35%..48%..60%..73%..86%..100% was finished.
[code]....
ERROR: Currently installed version of product with ID 'plesk' is not available from download site anymore.Please upgrade to the next available product version to receive software updates.Seems like the RPM got damaged, but I already fixed that part, now when I put "install" I'm geting the following
Installation started in background..Getting bootstrapper packages to installation list:
Following bootstrapper packages will be installed: (empty)
----------------
Getting packages to installation list:
Following packages will be installed: (empty)
----------------
Loaded plugins: fastestmirror
Patch for plesk 12.0.18 will not be installed since it is already applied.Error: You already have the latest version of product(s) and all selected components installed. Installation will not continue.HOWEVER the "mail" and mail server configuration no longer shows in "tools & settings".
View 1 Replies
View Related
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 19, 2015
My OS is CentOS 5.8.
Plesk is 11.0.9.
Having problems with failed daily domain backups. All databases that have been created by Plesk cannot be backed up, thus backup fails with the following message:
<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="error" log-location="/usr/local/psa/PMM/sessions/2015-02-19-044701.875/migration.result">
[Code]...
View 4 Replies
View Related
Dec 5, 2014
I get the following error in plesk i don't know how to resolve this
Unable to configure the web server: Execution failed.
Command: httpdmng Arguments: Array ( [0] => --reconfigure-all )
Details: Execution failed. Command: httpdmng Arguments: Array ( [0] => --reconfigure-server [1] => -no-restart )
[Code] .....
View 2 Replies
View Related
Jun 16, 2014
why but autoupdate fails. It doesn't give a reason why it cant backup.
For line of log :
START pp11.5.30-bootstrapper-11.5.30-cos5.build115131216.11 installing AT Thu Mar 27 07:43:37 CET 2014
Last lines of log :
===> Upgrading database
Trying to start service mysqld... mysqld (pid 24610) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 011005030
Version is OK, no need to create psa database.
Trying to backup MySQL database...
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
Trying to start psa...
**** Product prep-install for BASE failed.
***** problem report *****
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
STOP Bootstrapper 11.5.30 prep-install for BASE AT Tue Jun 17 04:04:48 CEST 2014
View 2 Replies
View Related
Feb 12, 2015
I'm new to Parallels Panel. I use version 11.0.9. I want to backup mysql database daily. First of all, what is the best way for daily database backup in plesk. I'm trying to do this in Scheduled Tasks and I use mysqldump command although I'm not sure.
I chose the time and day first and then I switched on the task. I typed the following command to Command line.
mysqldump -uusername -ppassword databasename | gzip -9 >/httpdocs/mydatabase.sql.gz
or
mysqldump -uusername -ppassword databasename >/httpdocs/mydatabase.sql.gz
This created only a blank file. When I use this without gzip, nothing changes.
1- Is mysqldump right command for database backup?
2- Should I define full path for mysqldump, gzip and database? If so, how can I find out the full path of mysqldump, gzip and my database? Because I can't see their locations in panel.
3- I can't see any error message. There is not any log file in httpdocs folder. Where does the log file exist?
4- It is weird but should the username be "database user" or should I write "root" ?
View 2 Replies
View Related
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
View Related
May 27, 2014
I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.
View 1 Replies
View Related
Mar 30, 2015
I cant connect to the Database WebAdmin. If I click the icon, i got an "File not found." in the opening tab. Back in Plesk I get the following:
ERROR: PlexkFatalException
Server id is undefined?
I even cant connect via ssh to the mysql part of my server. But the server is running and both of my two wordpress pages run smoothly. I know this page: [URL] .... – but as I sad, cant enter die mysql.
It seems something is wrong with the permissions. I'm on the point where I just want to reset everything database related. But how?
View 2 Replies
View Related
May 7, 2015
I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.
When I try to create one, i get this error :
error: the test connection to the database server has failed because of network problems: connection refused...
View 1 Replies
View Related
Jan 28, 2015
My Customers and I have Problems connecting to IMAP-Server. By moving through IMAP Folders I get the Massage "Unable to connect to your IMAP server. You may have exceeded the maximum number of connections to this server"
I know this Article: [URL] ... and all the other related to this issue.
[Code].....
View 9 Replies
View Related
Sep 28, 2014
Every time I log on plesk 11.09 I get an email from admin saying that due to maximum number of failed login attempts for admin, the account was blocked for 30 minutes.
First, I do not get failed login attempts, I log in every time.
Two, the account is not blocked, I can log in, out and back in as many times as I want without problem except that I get this email everytime.
View 3 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
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
Nov 20, 2014
When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Code:
Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm
...done.
done
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database
===> Cumulative APS controller database (apsc) upgrade has been started.
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
Reading package lists...
There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.
View 5 Replies
View Related
Dec 13, 2007
I have ubuntu 6 server version running.
I am trying to import a database I have however I cannot get it working for the last 2 hours!
I have tried various commands like logging into mysql entering the "use" command to use a database and then variations of the "source" command but my db.sql file doesn't run.
Also tried the full command
mysql -uroot -pMYPASS MYDBNAME < /var/www/site/db.sql
Neither seem to do anything.
PHPMYADMIN shows no database tables at all.
Running mySQL 5.
View 4 Replies
View Related
Apr 22, 2013
I have read about people wanting to change their database from MSSQL to MySQL. I however am wanting to change from MySQL to Microsoft SQL in our Plesk panel.
View 7 Replies
View Related
Jun 6, 2015
Is it possible to update the MySQL version on the db nodes from 5.1 to 5.5 or is it supported?
View 3 Replies
View Related
