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?
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 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 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 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 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"
we can import dataabse with phpmyadmin files which size is under 8meg
how can we change it for example to 50meg
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 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?
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.
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 am on an VPS , i want to know how different vanilla mysql is from mysql
since i got vanilla mysql , and want to use Phpmyadmin is it paossible with vanilla or i have to insall mysql?
also my old site database was installed on Mysql , would it work the same with vanilla mysql?
also how can i create an sql dataabe , username , passwrd using vaniall mysql?
And do i have to unistall vanilla mysql to install mysql
MySQL 5.0.27
phpMyAdmin 2.5.0
Php ver 4.4.0
IIS6 Win2003 Web Edition - dedicated
I cannot work out what is going wrong here. I have been up all night trying to work it out!
Have installed MySQL + PHPmyAdmin no errors no problems. Log into phpmyadmin and look at a database but it will not show how many records are in the field nor what size the records are. It says records - unknown, size unknown
I am using Windows XP (my laptop) to run a server for localized testing for a site that I run. I am using the WAMP5 on Windows XP.
I got everything setup (phpbb board) vanilla install. Everything went fine, no problems. The script uploaded all the tables on its own.
I pulled the database from the real server to drop into the test site.
Every time I try to upload a sql file that's 11.9Mb in size, I get a "Error: You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit." so I checked the configuration and set it to a 1024Mb file size and like 2048 memory size.
I even tried a 30Kb sized file and I still get the same error. What do I need to do to get this to work?
Also when I check all tables and use the drop down menu to select drop, it just bring my back to the start phpmyadmin page and nothing happens. I can drop the table individually, but that'll take too long, there are over 40 of them.
What else do I need to look for/configure so this will work?
It seems I am having issues with WHM/CPanel. I cannot connect to mysql via phpmyadmin through WHM as a root and get this error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
All users get the same error when they try to access mysql from cpanel. The access seems to be only for valid for 192.168.1.%
Would allowing access to localhost will help and how can I do that for all users?
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.
The most important requirement is that the webhost must be fast. It must have alot of bandwidth.
The disc space is not so important. 200 MB would be enough.
It must have PHP, MySQL and phpmyadmin installed.
Must be accesable through FTP.
There are offcourse more requirements. But the main thing is that i want it to be fast.
My pages will be only informative and exists of just mainly text and an image every now and then.
Do you know any fast webhosts that is good to handle websites with large amounts of visitors?
I'm looking for something around 6 dollars per month.
I dont know much about webhosting at all, so i'd appreciate any help i can get
Also i see websites where you can register a domain. But the prices vary, isn't a domain just a domain? What makes this price difference?
One of our resellers has an account.. When looking into cpanel, it says that that account is using 3300megs. When we go into the ftp of that account, in reality it is only using 1.3megs. This is a huge difference! Most of folders are empty.
We are using the latest version of WHM and Cpanel.
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 RelatedI 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 RelatedAnd 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 am trying to edit my database parameters by editing my /etc/my.cnf file. However I am new to SSH and can't seem to get this working. The parameter I wants to change in /etc/my.cnf file are as follows
max_connections 600