MYSQL Gives Access Error After Server Move
Jun 20, 2008
I can't find any straight answers when searching Google. I've been stuck in a what has become a nightmare server move for about 2 weeks now.
After finally getting a mysql.sock issue fixed I can get the MYSQL dbs over to the new server but it appears that their permissions need to be changed. Is there a way to handle this from the root level? I have roughly 120 dbs to process
I am moving from a VPS to a dedicated server - both have root access.
View 11 Replies
ADVERTISEMENT
Apr 21, 2008
Is it possible to move my mysql database to another server?
View 9 Replies
View Related
May 24, 2007
how can i move mysql db from remote server ? (via SSH or most pratical way)
suppose that...
source server
domain : google.com
host : localhost
user : zode
pass : 123
db : source
destination server
domain : yahoo.com
host : localhost
user : hala
pass : 456
db: target
View 2 Replies
View Related
Mar 21, 2008
After 2 years of application hosting on ixwebhosting.com i have overloaded their mysql servers for the forth time and now if i overload them again i'll get banned.
Each time i got overloaded My database was taken away for a almost a week and i had to beg everyone / write a letter to the CEO so they'll return the database.
I now need to sireously move to a VPS / Dedicated server
or my database will be deleted permenantly including all my 10 gigabytes of usergenerated data and content heh.
The wrost thing is i can't even monitor these overloads and ixwebhosting just take away your databases and say "STOP, you overloaded!" that's it - you're screwed.
I really modified my scripts these 2 days so i won't overload them again and get the final booting (that's after i paid 2 years upfront - 260$), but guess what, they can't even tell me if i'm now overloading the servers after i done all the tweaking.
Guess it's time to get all the data to my comuter before they say i have overloaded again and all my 12 my sites get blown away.
I need to switch fast i don't have much time as it seems and my most important site has 8k unique visitors per day - that's why the over loading occurs, heh, because im just too big - UNLIMITED MY ARSE.
I've been looking for a host and the best i found (after 2 days of forum readings and google searching ) where:
1. inmotionhosting VPS.
2. rackforce.com DDS.
3. Iweb.com
Please any suggestion / comments to where should i go to host will save my buissness, my main concern is my 8k per day site with 2.5 page views per user and 2 mysql queries per page.
looking for a good company with managed everything (I know nothing about hardware managment - i'm a php / mysql geek at the most) and technical support with great uptime and a good ping / connection to israel's area is a big plus.
View 16 Replies
View Related
Oct 2, 2007
how to do this in myphpadmin
also got cpanel if it helps.
View 5 Replies
View Related
May 11, 2008
how I can do to allow External Access Mysql Database on my server ? What's the procedure ?
View 1 Replies
View Related
Jun 28, 2008
After a full year of operation, I think I need to delete some log files. What types of files can I safely delete (and is deletion the best option, i.e. will the files be regenerated from zero length?)
For example, my server's error_log file is 193 Mb and my access_log file is 14 Mb. Can I "rm" them both?
Are there any other such files I can safely delete that occupy space on the server?
View 6 Replies
View Related
Mar 24, 2008
Since I have never worked on the server end of things I had a quick question for all you web hosting gurus.
Is it possible to have PHP installed on ONE single server and still have the ability for the server to work with both MS Access AND MySQL at the same time?
I would think YES, but I am being told by our server branch at my current job that this is not the case. They claim there is no way for the server on one machine to be able to handle both types of databases. Are they right?
If they are wrong and it is possible to have one server run both type of databases, what steps would be necessary to set up the server to handle both types? Do we need to tweak the php.ini file or is there another method of allowing the server the ability to work with both MySQL and MS Access.
Sorry if this question seems stupid or odd, as I said, I have minimal experience on the server end but I am confident that a server can handle both.
View 10 Replies
View Related
Apr 15, 2009
my /var partition is full,
im not sure if any files i can remove to get more free space on /var partition.
because there are more free space on /home,
i think if i can move all the /var/lib/mysql to /home/mysql,
if yes,howcan i move it and do any change,
can let the sql data do not lose,
andrun well in the feature ?
View 14 Replies
View Related
May 2, 2014
I am having a peculiar problem, when ever I attempt to access my server globally I get the dreaded 'No Data Received' error.
The machine is running Ubuntu 13.10 and is a dedicated server (I do not have GUI or physical access to the machine). All ports are open, iptables disabled, yet nothing works (running on port 80). I loaded the files onto a different computer at home and it works nicely, but not on the dedicated server.
Also, when the Apache server is off it says it can not connect in my browser, and when the server is on it says 'No Data Received' ...
View 4 Replies
View Related
Dec 18, 2007
I keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
View 5 Replies
View Related
Apr 4, 2007
I'm not sure I really understand the ins and outs of upgrading MySQL and I'm afraid to mess it up. From the MySQL site I see there's a 4.1.22 RPM available [url] and I'm running 4.0.18 (Your MySQL connection id is 2763253 to server version: 4.0.18-Max-log)
I'm not sure I want to bump it up all the way to 5, but I would like to run 4.1, but I also would like to stick with the RPMS, even after reading whatever I can find, I'm still not sure I understand what RPMs to install, here's what I have currently.
Code:
>> rpm -qa | grep -i mysql
php-mysql-4.3.11-1.1.rhel3.ct
MySQL-shared-compat-4.0.18-0
MySQL-Max-4.0.18-0
libdbi-dbd-mysql-0.6.5-5
MySQL-server-4.0.18-0
perl-DBD-MySQL-2.1021-4.EL3
MySQL-python-0.9.1-6
MySQL-client-4.0.18-0
MySQL-devel-4.0.18-0
There doesn't seem to be anything newer on the up2date server I use:
Code:
>>up2date --showall | grep -i mysql
MySQL-python-0.9.1-6.i386
libdbi-dbd-mysql-0.6.5-5.i386
mod_auth_mysql-20030510-2.ent.i386
mysql-3.23.58-16.RHEL3.1.i386
mysql-bench-3.23.58-16.RHEL3.1.i386
mysql-devel-3.23.58-16.RHEL3.1.i386
mysql-server-3.23.58-16.RHEL3.1.i386
perl-DBD-MySQL-2.1021-4.EL3.i386
php-mysql-4.3.2-39.ent.i386
qt-MySQL-3.1.2-14.RHEL3.i386
View 5 Replies
View Related
Jul 12, 2007
I have two hard disks, and I would like to move all of my MySQL data onto the second drive. My dilema is this; what is the best way to go about doing this? The tutorial I followed last night had me use cp to copy the /var/lib/mysql folder over to the second drive. However, it took ages to move one of my databases. It's a forum hosting database which has tons and tons of tables. It ran for about 5 hours and still didn't finish because I decided to stop it right there. I know it was working; but still, it took forever and I had to put it back up.
What would you do? Do you recommend say, copying just the 'mysql' database that has the users, and then taking a dump of all databases with mysqldump and moving it that way?
Also, is there any way using the cp command to continue what I started last night, but not write a database file if it hasn't chnaged at all?
View 8 Replies
View Related
Oct 30, 2014
We are using a server with Ubuntu 14.04 LTS and Plesk 12. When installing plesk, the vhosts directory is automatically created in /var/www/vhosts . Our problem is that /var is on a 120 GB SSD drive. We would like to move it to /data, which is a 2 TB drive. Whenever we used:
This KB-Article [URL] .... (exits with errors) this third-party documentation [URL] .... (Which is from a user who has the exact same problem with the same paths) all we get is ERROR 403 on our demo site. The site was created before the move and we also tried to create it after the move. The Plesk installation is fresh out of the box. There were absolutely no changes to the installation. Even the domain default or server default pages will not load anymore.
View 19 Replies
View Related
Jun 19, 2009
Trying to install Mysql 5 on a Windows 2003 server but getting this error attached.
For one, trying to follow this guideline
[url]
Download from:
[url]
(msi file, x86)
Filename: mysql-essential-5.1.35-win32.msi
View 14 Replies
View Related
Feb 14, 2008
Recently,Mysql has been a problem that is going down.So,I have to restart Mysql Service everyday. You can see for further information at here
Quote:
ERROR
Couldn't connect to database.
Please contact admin about this err. Back
DETAIL
2002 : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
This is the error when i restart Mysql Service via SSH
Quote:
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL SUCCESS!
what i should do and give me a solution to kill this error
View 2 Replies
View Related
Jan 21, 2007
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View 1 Replies
View Related
Jul 20, 2009
For window hosting are there any that offers sql db external access without ip limit?
I've seriously requested thought the forums and actually signed up with few but all of em are either offered it but not anymore(security issue) or not even offering at all.
If you have any experience with hosting company that actually does offer sql db external access please share please!
vps nor dedicated servers are not my choice unfortunatley
and i don't think there's any free hosting that offers this. 99% freehostings use localhost
View 1 Replies
View Related
Jun 5, 2009
I've setup a mysql user and assigned a password for it. When I try logging in to it with
Quote:
mysql -u USERNAME -p
and then providing the password I get an error:
Quote:
ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: YES)
I don't have trouble logging in as root and when I check the user table there, the password assigned to the user is same as the value the mysql function PASSWORD gives me. Really driving me nuts here, why is it telling me the password is wrong when it's not?
I've tried: Restarting mysql
setting new password
changing username
Using mysql server 5.1.34
View 5 Replies
View Related
Mar 24, 2009
I run a shared hosting
OS:centos with whm/cpanel
and would like to restrict access to mysql database
example:
username:user1 created database:user1_db1,user1_db2 etc..
and can only access his own databases
so user2 can't access user1_db1.db2 etc.. and user1 can't access user2_db1,db2 etc..
View 4 Replies
View Related
May 6, 2009
I have a Ubuntu Lamp server setup in my building which is used for development purposes.
So I also have phpmyadmin setup and am using a Mysql Query browser and Mysql Administrator desktop programs to administor the database on the server. However I am not able to connect to the server from my desktop. I am able to login to my myphpadmin but not able to login via the Mysql Query Browser program.
Hopwing someone can help. I have read about port forwarding and also read a post about editing the my.cnf file on the server and changing the Bind-Address= 127.0.0.1 to the actual hostname but before I start editing the actual configuration files on the server I want to see if their is another way as I am worried that if I change the me.conf file that the phpmyadmin may stop working?
View 14 Replies
View Related
Jul 16, 2008
Can anyone tell me which hosting allow remote access of mysql?
View 10 Replies
View Related
Feb 8, 2009
I have subscribed an account in Powweb but since the Powweb does not allow MySQL remote access I need to find another hosting that allow MySQL remote access.
Wich hosting with MySQL remote access do you know?
View 3 Replies
View Related
Jan 28, 2008
What can I do to secure access to my MySQL database to stop it from getting compromised from hackers?
Is there any way I can restrict access to the MySQL database to my IP only?
The database is for an IPB 2.3.4 forum and the username/password are stored in a conf_global.php file that is CHMODed 0444.
View 5 Replies
View Related
