Import .sql.gz Database
Dec 13, 2008how 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
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
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 RelatedHow do you import a database using webmin?
View 8 Replies View RelatedHow 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'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.
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 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"
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.
my server is Linux with PLESK, one of our customers trying to import data to database, the data is in Unicode (Persian) and when he import that data show? in web site.
View 2 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 am not sure if this is the right sub-forum to post the question.
it is that i my a forum running with php and mysql,
the version of it is 4.1 now,
i wnat to move the forum to another server,
but the mysql version of the server is 4.0,
i try to backup the .sql form phpmyadmin and import form phpmyadmin,too.
but it failed,
some article tell me that i should change some setting in the .sql file,
but i try and failed,
can anyone teach me how can i process it?
I have a sql backup and I just want to restore the attachment table from it! , can anyone explain me how to do so?
View 4 Replies View RelatedDoes anyone know if is it possible? If yes, how could I do this?
View 1 Replies View RelatedI 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
And now after creating a Joomla! site for a school that will be moving to my server from a local small isp that doesn't have a control panel (just a screen to allow users to set-up their email name and pwd) I'm stuck with trying to figure out how to set up their email accounts with their current password.
There are about 40 accounts that I can add manually, but when I change the nameservers, these teachers and staff are going to be at a loss as what to do; like I am at the moment.
I want to move domain names. However, I got a lot of good articles in a blog. How can I move the articles from one to another?
View 4 Replies View RelatedChrome/Chromium don't offer to "remember this password" if using https with a self signed, or no, certificate, which is pretty frustrating when your job requires regular logins to various Plesk installations!
The trick, apparently, is to import your self signed certificates into Chrome's chrome://settings/certificates list, so I'm trying to do this with Plesk's default panel certificate.
From Tools & Settings -> SSL Certificates, I've hit the 'Download the Panel's SSL Certificate' link to get the .pem file but when I import this into Chrome I'm asked to provide the password it was encrypted with. Where would I find this password? Or do I need to replace the default with my own self-signed?
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?
How I can import my backups from remote backup space to my VPS.
View 6 Replies View RelatedWe have too many DNS servers such as BIND, PowerDNS, NSD on different platform.I need transfer all zones to Plsek server.Is there a ready-made solution import dns zones using axfr?
View 3 Replies View RelatedI've a sandbox, when i upload my package, the package disappear.
With aps build package and aps lint package I have no error and no warning, and on the panel when i import the package, simply disappears.
There is a log, a sign, I can not find the error.
I use APS 1.2
since upgrading PPA, I noticed that in the External Applications section, all the APS packages have a column "imported" and "certification" - what these are/mean?
I hit "import" on the wordpress package - but what it is doing and why it would be to our advantage to import an APS package, rather than have them externally hosted so they're always the latest version.
I would like to know if is possible to export Plesk firewall rules from Plesk 9.5.4 to Plesk 11.5.30 with panel.
View 2 Replies View Related