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"
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.
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.
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
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 RelatedI 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.
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
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?
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 RelatedI'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 RelatedI 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?
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
I'm change “upload_max_filesize” & “post_max_size” in php.in but when i wanna import sql show me>>>(Max: 2,048MiB)
View 1 Replies View RelatedMy friend has a Hebrew Database and I wanted to know the best way to import it? (i have shell access).
View 4 Replies View RelatedHow do you import a database using webmin?
View 8 Replies View Relatedhow to enable bzip2 compression in phpmyadmin.
View 5 Replies View RelatedI'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 ?
How to import mysql dump file to database by SSH?
How to import mysql database host to other host database by SSH?
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.
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.
how to make backups separately of all domains and clients, without going into their panel and configuring one by one?
View 2 Replies View RelatedI'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/domain.com
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
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.
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)?