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


Plesk 12.x / Windows :: How To Import Existing MS SQL Database Into Subscription

Apr 2, 2015

I've created a website for a client using Sitefinity CMS and MS SQL Server 2008 R2. I've transferred the database from my local SQL server to the production server using SQL Management Studio.

I've created a customer and subscription for hosting the website and it's all up and running perfectly. However, I want to automate the backup of the SQL database for the website which I can only do if the subscription knows about the SQL database for that website. So, how do I associate the two? How do I get the database to show up in plesk for that customer such that it can be part of the scheduled backups - and of course also somethign I could restore via plesk if I had too?

The database exists. It wasn't create via plesk in any way, but I want plesk to be able to back it up, and ideally for it to show up in the customers subscription, etc.

View 1 Replies View Related

Plesk 11.x / Windows :: Import MySQL - Database Failed After Upgrade

Aug 13, 2013

Since we upgraded to Plesk 11.5 or (I'm not shure) the last Update 12, user can not import MySQL-Databases anymore.

If the user open phpMyAdmin for import and select the database and click on Ok, phpMyAdmin does nothing.

I heard that could be a problem with JQUERY and I checked the files in ParallelsadminhtdocsdomainsdatabasesphpMyAdminjsjquery and all files seems to be there.

Only if I check the source of the phpMyAdmin Import-Website it seems, there is a problem with jquery-1.6.2+fix-9521.js.

But how I can fix this problem for all Windows-Servers.

View 19 Replies View Related

Plesk 12.x / Linux :: Can't Increase Phpmyadmin Max Upload / Import File Size

Jan 2, 2015

I'm running Plesk 12. I install it today, using the ISO which parallels provides, which includes centos 6.5 and preinstalled Plesk 12 in my vps. Then I logged in plesk, and I did everything it wants. Then I upgraded my php, to php 5.4.36 according to the manual that Paralells provides, and then I tried to increase the max upload file size for phpmyadmin. I have edited my /usr/local/psa/admin/conf/php.ini file and tried to restart using with 3 different ways using terminal:

1st: service sw-cp-server restart
2st: /etc/init.d/psa stop
/etc/init.d/psa start
3st: reboot (which rebooted all the vps)

My php.ini file is:

short_open_tag = On
y2k_compliance = Off
output_buffering = Off
max_execution_time = 600
max_input_time = 600
memory_limit = 256M
max_file_uploads = 99999
max_input_vars = 2000

[Code] ....

However, when I'm trying to import a 31mb sql file, I always get that error, and only some of my tables are being imported:

#1153 - Got a packet bigger than 'max_allowed_packet' bytes

View 2 Replies View Related

Plesk 11.x / Linux :: Increase Import Database Size

May 4, 2015

I have a virtual server with CentOS 6.4 (Final) and Plesk 11.5.30 and I would like to increase the database size to import because right now it's only 2MB and I have to put online a website with 10MB.

View 5 Replies View Related

Import 16 Meg File In Phpmyadmin

Aug 14, 2008

I have a very good free web hosting company. My one user needs to be able to upload a 16 meg sql file in php. I tried bigphp, but it game me an error that the sql file doesent have a semicolon followed by a linebreak at the end of each query in the file.

I know there is some sort of SSH command i can run to import this sql file to his account. I am using layered panel. So what is the easiest way here?

Also i have 20MB php.ini settings for uploads, post size, etc.

View 5 Replies View Related

How To Increase Import Max File In PhpMyAdmin

Dec 15, 2008

I have CentOs 5 With LxAdmin

My Current Import Max File in PhpMyAdmin is 8192 KiB

I have Changed Values in php.ini and my.cnf But Still No Luck At ALL, Its Not Working

View 4 Replies View Related

Edit PhpMyAdmin MySQL Max Import Size (Max: 8,192 KiB)

May 31, 2009

I currently am running on a VPS and I'm trying to edit the max size a user can upload through phpMyAdmin. I have tried editing the php.ini file located at /etc/php.ini to find it wasn't the right file.

Where do I need to go via SSH to edit the proper file?

View 6 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 :: 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 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

Import .sql.gz Database

Dec 13, 2008

how can import a .sql.gz database to mysql? i cant do it with following command:
mysql -p -u root uur445_db < wqee2_master_1.sql.gz

View 2 Replies View Related

Plesk 12.x / Windows :: Max File Upload In PHPMyAdmin

Jul 10, 2015

I'm change “upload_max_filesize” & “post_max_size” in but when i wanna import sql show me>>>(Max: 2,048MiB)

View 1 Replies View Related

Hebrew Database Import

Jul 2, 2009

My friend has a Hebrew Database and I wanted to know the best way to import it? (i have shell access).

View 4 Replies View Related

How To Import Database Through Webmin?

Jun 26, 2009

How do you import a database using webmin?

View 8 Replies View Related

Plesk 11.x / Windows :: How To Enable Bzip2 Compression In Phpmyadmin

Jan 30, 2014

how to enable bzip2 compression in phpmyadmin.

View 5 Replies View Related

Plesk 11.x / Windows :: PhpMyAdmin Not Installed - Button Disabled In Panel

Sep 22, 2014

I'm on plesk 11.x on Windows.

There are a reason because phpmyadmin is not installed and the button in the panel WebAdmin is disabled ?

In plesk 11.5 for linux phpmyadmin is installed from default.

How to install it via plesk ?

View 2 Replies View Related

How To Import Mysql Dump File To Database By SSH

May 19, 2009

How to import mysql dump file to database by SSH?

How to import mysql database host to other host database by SSH?

View 4 Replies View Related

Trying To Import Mysql Database Via CLI In Ubuntu Linux

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

Plesk 11.x / Windows :: Separate Backups Of All Sites?

Sep 8, 2013

I do wanted to know if there is any option to program plesk, so that it does separately backups of all sites instead of doing a globally backup of all things in one file.

I do not mind that people an synchronize their account with one of their ftp servers to do backups but what I do want is me also to do backups of all sites separately.

View 5 Replies View Related

Plesk 11.x / Windows :: Make Backups Separately Of All Domains And Clients?

Sep 13, 2013

how to make backups separately of all domains and clients, without going into their panel and configuring one by one?

View 2 Replies View Related

Plesk 11.x / Windows :: Backups Repo Not Affected On Client Quota

May 5, 2014

I've an issue when i tried to create a backup repository by the client control panel, The backup already created but it's not affected on the client disk space !!

It's put in Crogram Files/Paralles/Plesk/Backup/reseller/resellername/clients/

Now, I have critical disk space usage because the one client has schedule daily backups and it's not affected on his account usage!!

1- I've check for permissions and repair plesk database.
2- I've make repair quota.
3- Updated plesk

PLesk v: 11.0.9
Windows server 2008 R2 Datacenter

View 2 Replies View Related

PhpMyAdmin, CPanel And Remote Database

Feb 18, 2008

I've just purchased a second server of which I wish to use a database server for a number of my databases and I'd like manage it remotely (from the web server) via phpmyadmin.

I've configured my firewall and granted access to the web server on root@webserverip and also username@webserverip (username being just one of the database accounts I wish to grant access in order to test this). Accessing mysql remotely from the webserver now works on both accounts (via ssh and php).

However, having configured the phpmyadmin config file to include the ip (network ip) of the 2nd server I am unable to see the 2nd server when logged in to phpmyadmin. I just have the usual root@localhost and username@localhost.

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

Copyrights 2005-15, All rights reserved