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


ADVERTISEMENT

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

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

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

Phpmyadmin Large Database Backup

Feb 5, 2007

I have a large database 800MB and the export zip & gzip option does not work on this size database export.

works fine on upto 30MB table sizes, does phpmyadmin not support large table
export/backup using gzip or zip?

If its the case that i should be able to use the zip options then what would i look for to put this problem right?

if its the case large table databases are not supported what could i use instead to backup the database tables with compression (gzip)?

View 1 Replies View Related

Plesk 12.x / Linux :: PHPMyAdmin Database Upload

Jul 2, 2015

We are having an issue upload a 300mb mysql database to phpmyadmin.. With direct mysql file, t stops and only copies a few tables, stating to reupload to continue (which it doesn't and states that there are pre-existing tables). With zip file, it does the same.. at one point at 504 error occurred.

View 4 Replies View Related

Plesk 12.x / Linux :: Updating Database Name Of WordPress Installation Through Phpmyadmin Panel

Jan 21, 2015

I found out a easy way to update the Database name of a WP installation through phpmyadmin panel, However I can't seem to update or refresh the Parallels WP Settings with correct information. Is this a bug?

This is how to reproduce:

From phpMyAdmin select the database you want to select, in the tabs there's one called Operations, Go to the rename section.

Update the user privileges to the new Database name and remove the old privileges (save)
Then manually update the wp-config file which contains the 'Database name' (save)
Then goto Parallels Plesk > Websites & Domains> WordPress Installations > Change Settings

Here you should notice the Change Settings for the WordPress Installation still contains the old Database name.

Is there any way of updating this?

View 12 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

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

Plesk 12.x / Linux :: Webalizer To Awstats - Importing Current Data

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

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 / Windows :: How To Import Phpmyadmin Database Backups

Mar 17, 2015

I expored my databse fom my old hoster and want to import it to my new Windows Server 2012 r2 vps Server but I can't find that option:

I found this link: URL....

my dashboard looks like this, it is missing the Backup Manager: Image: "dashboard.png"

View 4 Replies View Related

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 View Related

Plesk 12.x / Linux :: Using Standalone Phpmyadmin

Apr 9, 2015

Recently i installed the latest Multiple PHP functionality for Plesk and assigned PHP version 5.6 to a subdomain (for example demo.mywebsite.com) and i installed a Wordpress. So i thought i would try something out by installing a custom standalone version of phpmyadmin (version 4.4.1.1) and when i load the setup i ran into the following issue on the index.php page:

Code:
Warning in ./libraries/session.inc.php#101
session_start(): open(/var/lib/php/sessions/sess_dubv0rqju6bejfplkgcsl98qsonviukg, O_RDWR) failed: No such file or directory (2)
Backtrace
./libraries/session.inc.php#101: session_start()
./libraries/common.inc.php#352: require(./libraries/session.inc.php)
./phpinfo.php#12: require_once(./libraries/common.inc.php)
note 1. Due to privacy i have called domain 'demo.mywesite.com' and subfolder 'root'

[code]....

View 5 Replies View Related

Plesk 11.x / Linux :: Country List In PHPMyAdmin

Jan 22, 2015

Where I can get full country list ? I need it to my new site and there missing lot of country in the list. I have 109 country but world have more ....

List must be like this:

(1, 'af', 'Afghanistan'),
(2, 'dz', 'Algeria'),
(3, 'ar', 'Argentina'),
(4, 'au', 'Australia'),

Have search on internet but not find good sites!

View 2 Replies View Related

Plesk 12.x / Linux :: Restore Backup Via PHPMyAdmin

Dec 6, 2014

I made a backup of my website with plesk backup manager on an external FTP, now I want to restore this backup on a new server which isn't using plesk, for test purposes. I've downloaded the backup (which is in .tar) on my PC, and extracted all files firstly from the general .tar archive, then the user_data from .tgz. Then to extract all the databases (they were in a folder "databases" after I've extracted the general .tar file), I extracted them from database_name_145536536.tgz, then from database_name_145536536.tar, so that now I've a series of "database_name_145536536" files. (145536536 are some example numbers).

I'm interested in restoring both files and mysql databases.

To restore the files, I can simply use the extracted files from the user_data archive.

To restore the mysql databases, I tried to do "mysql -p -u username database_name < file" and everything seemed to work fine.

Is this process ok? Is it 100% safe and sure or I could face some bugs?

View 8 Replies View Related

Plesk 12.x / Linux :: PHPMyAdmin Permissions Change

Jan 28, 2015

CentOS 6.6
Plesk 12.0.18
64-bit

At some point, not sure when, PHPMyAdmin's (as accessed through the admin panel by clicking on a customer, manage hosting, databases, etc) permissions have changed such that I cannot view, edit or add MySQL routines/procedures. This appears to have occurred system-wide, though I have not checked every database on the server.

Is there a fix to get the permissions set so that I can make these changes again?

View 3 Replies View Related

Plesk 12.x / Linux :: Unknown Database Atmail When Selecting Database

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

Plesk 11.x / Linux :: Can't Access PhpMyAdmin From Direct Link

Jan 3, 2015

Plesk: 12.0.18
phpMyAdmin: 4.2.5

When I try to access phpMyAdmin directly from the link: [URL] ....

I get the following error:

Welcome to phpMyAdmin

You probably did not create a configuration file. You might want to use the setup script to create one.

Error

MySQL said: Documentation
Cannot connect: invalid settings.
Retry to connectClick to expand...

View 3 Replies View Related

Plesk 12.x / Linux :: PhpMyAdmin Running On Nginx But It Is Not Installed

Jan 3, 2015

i've uninstalled nginx and php-fm from plesk panel.but phpmyadmin info still showing it is running on nginx 1.6 and while uploading sql file i'm getting 503 gateway error.

View 3 Replies View Related

Plesk 12.x / Linux :: PhpMyAdmin Incorrect Web Server Information

Sep 9, 2014

I deleted Nginx web server and reverse proxy support from Plesk. There is no this service on server, but I still see on the web server informations like nginx/1.6.0 at phpmyadmin page.

View 6 Replies View Related

Plesk 12.x / Linux :: Download Large Backup

Aug 23, 2014

I have backup my domain with Backup Manager and it created 47 GB of backup. If I try to download I recive error 504. How can I download this backup?

View 4 Replies View Related

Plesk 12.x / Linux :: PhpMyAdmin Cannot Connect - Config File Missing

Mar 8, 2015

I installed Plesk on a VPS running on Ubuntu 14.04. When I try to open phpMyAdmin the following error message appears:

You probably did not create a configuration file. You might want to use the setup script to create one.

Error

MySQL said: cannot connect: invalid settings.

When I try to click on the setup script link another error message pops up:

Error in Processing Request
Error code: 404
Error text: Not Found

What do I have to do to make phpMyAdmin work?

View 1 Replies View Related

Plesk 11.x / Linux :: Mysql 1045 Access Denied With PhpMyAdmin

Nov 2, 2014

One of my users is unable to connect to his database using phpMyAdmin. The query is:

LOAD DATA INFILE '/tmp/phpYXZFfZ' INTO TABLE `count` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '' LINES TERMINATED BY '

And mysql reports:

#1045 - Access denied for user '<USERNAME>'@'%' (using password: YES)

The funny part is that I can connect without any problems from a shell like this:

mysql -u <USERNAME> -p<PASSWORD> -D <DATABASE_NAME>.

This server has been recently migrated from plesk9 to plesk11.5, running on a centos6 OS.

View 1 Replies View Related

Plesk 12.x / Linux :: Phpmyadmin - All Users (subscriptions) Has Access To All Databases

Sep 19, 2014

today we notice that all subscriptions on Plesk when we access phpmyadmin has access to all databases,it was a Plesk update that can be done this ?

I don't remember to update anything during this days to this happen.

View 1 Replies View Related







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