Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Web Hosting


Advertisements:




SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







MYSQL Error "Could Not Connect To The Database"


Last night i went to install GD on my server(Linux RH) I went through the process /scripts/easyapache and at the end of it gave me this error

"...Unable to connect to host: 127.0.0.1......Failed......Unable to connect to
host: 127.0.0.1......Fail
ed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect
to host: 127.0.0.1.....
.Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to
connect to host: 127.0.0.1
......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable
to connect to host: 127.
0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed......Unable to connect to
host: 127.0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed...
The was no content, the test may be unable to connect to 8080 simply because
tomcat is still initila
izing.
You can try to go to
http://localhost:8080/
to manually check it.
-- End test 'Basic tomcat port running test' --
Post check of 'httpd' process Ok
-- End post apache restart tests --
Executing '/scripts/initfpsuexec'
Executing '/scripts/initsslhttpd'
Executing '/scripts/gentomcatlist2'
Compiling report...
Sending report (336 bytes)...
If you want to create a support ticket with cPanel regarding this please
reference 'BuildAP Report
Id': '528932'
Report processed.

You can change how PHP is configured.
As root, simply execute:
/usr/local/cpanel/bin/rebuild_phpconf --help
for more information.

Build Complete
Verbose logfile is at '/usr/local/cpanel/logs/easy/apache/build.1198389830'

Now I am unable to connect to MYSQL databases, MYSQL is still running from what I can see. I have base knowlage of Linux as well.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
MySQL Cannot Connect To Database Via PHP
I got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database.

It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs.

I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS.

I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem.

All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts.

I just added an hourly crontab so as to restart the MySQL server as a stop gap.

View Replies!   View Related
Is It Possible To Make Joomla Connect To An External Mysql Database Server
Is it possible to make Joomla connect to an external mysql database server?

Meaning, the database for Joomla won't be local, but on another server.

Will it work by just entering the mysql hostname, user and password in Joomla's config?

What issues might arose by doing this?

View Replies!   View Related
Error: Warning: Mysql_connect() [function.mysql-connect]
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/.../public_html/enhu.com/includes/connection.php on line 5

Database connection failed: Access denied for user 'root'@'localhost' (using password: YES)

i'm using wamp.

how must i fix this error?

View Replies!   View Related
Joomla Installation - Username/Password Incorrect MySQL Database Error
I am trying to install Joomla on httpme.com but I seem to have problems with it recognising the username/password. Could it be a localhost issue or something?

I just can't seem to get a solution to this. I am referring to step 1 of the Joomla installation.

View Replies!   View Related
Could Not Connect To Database
I recently tried installing phpbb forum via fantastico and everytime I try I get the error "phpbb critical error" "could not connect to database"

I also get an error connecting to database when I try installing SMF.

I checked the configuration/information and the password and username is all correct.

View Replies!   View Related
Cannot Connect To Database ; Errno.: 2003
I'm having trouble to connect my site to the MYSQL server. The condition is like this:

My site is running under 5 http servers and all are serve using a mysql server. Recently, I have changed the ip address of all the servers due to the ip migration at the datacenter. After the changes, all my http server having problem to connect to mysql server. It shows the error like below:

Quote:

Error: Can't connect to MySQL server on '123.456.789.2' (4)
Errno.: 2003

However, I tried to establish a connection by placing the http file into mysql server.

Only this site can be shown up correctly. Means, there's actually no problem with the Mysql Server.

Can I know what's the problem actually? I guess there might be some setting of the mysql server blocking the connection from my other servers. Where do we normally do the setting for this? I'm quite new in server stuff and wish to get some advice from you all...

View Replies!   View Related
"Can't Connect To Local MySQL Server" + "IPS Driver Error"
During peak times (especially weekends) many of my site's users have been reporting intermittent 'IPS Driver Errors' in the forums and the following error in the coppermine gallery:

Quote:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)

(The forums and the gallery are the main parts of the site).

I'm assuming that the site is having problems handling the number of users trying to connect to SQL. I tried increasing the max_connections and max_user_connections settings in my.cnf but it doesn't seem to have made a significant difference.

What do I need to do to fix this? Would I need to upgrade my server specs or is it something to do with the server settings?

my server specs: AMD Dual/Dual Opteron 270 with 4GB RAM.

View Replies!   View Related
Horde/squirrelmail:: DB Error: Connect Failed
trying to get into my horde or squirrelmail account on my server and getting the following:

A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.

View Replies!   View Related
Connect To MySQL DB Only On Certain User
I am using cPanel 11 (stable release) on a CentOS 5 server and would like to make it so that a certain database can only be connected to from the cPanel user that it is under (ie. user1_db can only be connected to from the user "user1" on the same server).

View Replies!   View Related
MySQL Can't Connect To Socket.....
I saw following error in some of my site in my server.

Coppermine critical error:
Unable to connect to database !

MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

or following error :

Invalid mysql server connection

Please help me how can I resolve this error !

/etc/my.cnf :

[mysqld]
datadir=/var/lib/mysql
skip-locking
skip-innodb
skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=16M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=64M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M ## 1MB for every 1GB of RAM
read_buffer_size=1M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

My server details :
1 GB RAM
P4 3.00 HT

View Replies!   View Related
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
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 Replies!   View Related
Users Cannot Connect To MySQL Via Phpmyadmin
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?

View Replies!   View Related
Mysql Connect Problem After Easyapache
I updated my php to 4.4.8 via easyapache. But after that my scripts couldn't connect the databases?

View Replies!   View Related
Error :: Rndc: Connect Failed: 127.0.0.1#953: Connection Refused
i have a vps

and all my site not working!

i got this error:

rndc: connect failed: 127.0.0.1#953: connection refused

View Replies!   View Related
Users Cannot Connect To Remote MySQL Server
I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did.

What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?

View Replies!   View Related
Can't Connect To MySQL Server On 'localhost' (10055)
Do you guys know anything about this?

My server works perfectly with INSERT, UPDATE, DELETE for mysql.
but after like 12 hours later, my application crashes and I get this
"Can't connect to MySQL server on 'localhost' (10055)" and I would have to restart my applications and everything will be working perfectly.

Do you guys have any idea why this happen?

I do have a lot of connections coming in and out of my server. Would that mean anything?

View Replies!   View Related
Can't Connect To Local MySQL Server Through Socket
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/thesymbi/public_html/includes/class_core.php on line 274

I get this around 50 times a day!
I am fed up!

View Replies!   View Related
Connect To Mysql From Many Remote Virtual Hosts
I have a set up where server 1 holds a mysql DB and a virtual host. server 2 holds many virtual hosts in apache (16) connecting to this DB.

The virtual hosts all hold the same script, but the single VH on server 1 receives about the same amount of visits as all the VHs of server 2.

server 1 is very busy at times, like 100% CPU and a load around 10 for long period of times.
server 2 is not very busy, around 30% CPU usage and 0.6 CPU load.

Yet, users on server 2 experience *much slower* response times than the ones on server 1.

The obvious reason could be the network between the two, but I'm not convinced (6 seconds for a query run from server 2 when it brings back 1 row and takes 0.01 second from server 1).

I was wondering what other reasons it could be.

The mysql processlist is weird:

Code:
mysql> show processlist;
+-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+
| 81817 | mysite | localhost | mysite | Sleep | 865 | | NULL |
| 94992 | mysite | server2:47927 | mysite | Sleep | 188 | | NULL |
| 96890 | mysite | server2:50881 | mysite | Sleep | 26 | | NULL |
| 97213 | mysite | server2:51010 | mysite | Sleep | 22 | | NULL |
| 97391 | mysite | server2:51085 | mysite | Sleep | 36 | | NULL |
| 97919 | mysite | server2:51300 | mysite | Sleep | 49 | | NULL |
| 97927 | mysite | server2:51306 | NULL | Sleep | 49 | | NULL |
| 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL
| 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL |
| 97958 | mysite | server2:51321 | mysite | Sleep | 26 | | NULL |
| 97961 | mysite | server2:51323 | mysite | Sleep | 46 | | NULL |
| 98104 | mysite | server2:51344 | mysite | Sleep | 39 | | NULL |
| 98169 | mysite | server2:51376 | NULL | Sleep | 36 | | NULL |
| 98177 | mysite | server2:51388 | mysite | Sleep | 9 | | NULL |
| 98365 | mysite | server2:51461 | mysite | Sleep | 26 | | NULL |
| 98377 | mysite | server2:51427 | mysite | Sleep | 26 | | NULL |
| 98380 | mysite | server2:51468 | mysite | Sleep | 6 | | NULL |
| 98394 | mysite | server2:51474 | mysite | Sleep | 26 | | NULL |
| 98404 | mysite | server2:51479 | mysite | Sleep | 26 | | NULL |
| 98418 | mysite | server2:51486 | mysite | Sleep | 26 | | NULL |
| 98419 | mysite | server2:51487 | mysite | Sleep | 26 | | NULL |
| 98429 | mysite | server2:51496 | mysite | Sleep | 2 | | NULL |
| 98503 | mysite | server2:51520 | mysite | Sleep | 22 | | NULL |
| 98512 | mysite | server2:51524 | mysite | Sleep | 22 | | NULL |
| 98514 | mysite | server2:51525 | mysite | Sleep | 20 | | NULL |
| 98519 | mysite | server2:51526 | mysite | Sleep | 22 | | NULL |
| 98557 | mysite | server2:51514 | mysite | Sleep | 21 | | NULL |
| 98568 | mysite | server2:51548 | mysite | Sleep | 20 | | NULL |
| 98581 | mysite | server2:51557 | mysite | Sleep | 5 | | NULL |
| 98617 | mysite | server2:51572 | mysite | Sleep | 18 | | NULL |
| 98620 | mysite | server2:51574 | NULL | Sleep | 18 | | NULL |
| 98630 | mysite | server2:51577 | mysite | Sleep | 17 | | NULL |
| 98644 | mysite | server2:51584 | mysite | Sleep | 17 | | NULL |
| 98681 | mysite | server2:51601 | mysite | Sleep | 15 | | NULL |
| 98698 | mysite | server2:51604 | mysite | Sleep | 14 | | NULL |
| 98704 | mysite | server2:51606 | mysite | Sleep | 14 | | NULL |
| 98714 | mysite | server2:51610 | NULL | Sleep | 14 | | NULL |
| 98736 | mysite | server2:51619 | NULL | Sleep | 13 | | NULL |
| 98748 | mysite | server2:51626 | NULL | Sleep | 12 | | NULL |
| 98753 | mysite | server2:51628 | mysite | Sleep | 12 | | NULL |
| 98785 | mysite | server2:51635 | mysite | Sleep | 11 | | NULL |
| 98820 | mysite | server2:51654 | mysite | Sleep | 10 | | NULL |
| 98821 | mysite | server2:51655 | mysite | Sleep | 10 | | NULL |
| 98822 | mysite | server2:51656 | mysite | Sleep | 10 | | NULL |
| 98823 | mysite | server2:51657 | mysite | Sleep | 10 | | NULL |
| 98836 | mysite | server2:51660 | mysite | Sleep | 9 | | NULL |
| 98840 | mysite | server2:51662 | NULL | Sleep | 9 | | NULL |
| 98841 | mysite | localhost | NULL | Query | 0 | NULL | show processlist |
| 98901 | mysite | server2:51680 | mysite | Sleep | 6 | | NULL |
| 98903 | mysite | server2:51651 | mysite | Sleep | 7 | | NULL |
| 98920 | mysite | server2:51684 | mysite | Sleep | 6 | | NULL |
| 98947 | mysite | localhost | mysite | Sleep | 1 | | NULL |
| 98954 | mysite | server2:51696 | mysite | Sleep | 5 | | NULL |
| 99024 | mysite | server2:51710 | mysite | Sleep | 1 | | NULL |
| 99031 | mysite | server2:51712 | mysite | Sleep | 2 | | NULL |
| 99032 | mysite | server2:51686 | mysite | Sleep | 2 | | NULL |
| 99041 | mysite | server2:51694 | mysite | Sleep | 2 | | NULL |
| 99049 | mysite | server2:51717 | mysite | Sleep | 2 | | NULL |
| 99058 | mysite | server2:51720 | mysite | Sleep | 1 | | NULL |
| 99063 | mysite | server2:51685 | mysite | Sleep | 1 | | NULL |
| 99064 | mysite | server2:51722 | mysite | Sleep | 2 | | NULL |
| 99073 | mysite | localhost | mysite | Sleep | 1 | | NULL |
| 99075 | mysite | server2:51724 | mysite | Sleep | 1 | | NULL |
| 99086 | mysite | localhost | mysite | Query | 1 | Creating tmp table | SELECT DISTINCT * |
| 99089 | mysite | localhost | mysite | Sleep | 1 | | NULL |
+-------+----------+---------------+----------+---------+------+-----------

Why so many sleeping processes from server 2, and none or almost none from server 1 ?
Is it normal that every query from server 2 is open on a different port ? Should they be grouped by virtual host, or is there one different port for each script running concurrently?

What could be a reason for server 2 having problems to open connections on server 1, and how to solve it?

Right now I'm about to deport more users from server 1 to new virtual hosts on server 2, hoping it will lower the load on the first machine and overall accelerate the response times. I just thought I'd post here first because this all seems very weird to me and i thought someone with an external look might tell me what I'm doing wrong. And also if network would be the problem maybe that's not the clever thing to do to make more users remote.

View Replies!   View Related
Database Error
I have a client who moved a site from one linux server to another. This site uses a script with members. The script worked fine on the old server, but on the new one, when members try to update their information, they get this error:

Exchange process unavailable at this time because of database is conducting scheduled task.

Please try back in a few minutes

What can I do to troubleshoot this?

View Replies!   View Related
Error In My Dns Server : Rndc: Connect Failed: 127.0.0.1#953: Connection Refused
i got this error :

rndc: connect failed: 127.0.0.1#953: connection refused

oot@server [/]# rndc status
rndc: connect failed: 127.0.0.1#953: connection refused

root@server [/]# /etc/init.d/named status
rndc: connect failed: 127.0.0.1#953: connection refused
named is stopped

root@server [/]# /scripts/fixndc
Named could not be restarted, any obvious config errors should show up below this line.
No critical problems found, will attempt to regenerate keys regardless.
warn [fixrndc] /usr/sbin/rndc status failed: rndc: connect failed: 127.0.0.1#953: connection refused
Creating rndc.conf
Creating /etc/rndc.key
warn [fixrndc] /usr/sbin/rndc status failed: rndc: connect failed: 127.0.0.1#953: connection refused
Restarting named
warn [fixrndc] /usr/sbin/rndc status failed: rndc: connect failed: 127.0.0.1#953: connection refused
/scripts/fixrndc failed to fix the rndc key (or named is otherwise broken), please investigate manually

and i have try to reload the rndc but i got this error :

root@server [~]# rndc reload
rndc: connect failed: 127.0.0.1#953: connection refused

my vps info : linux os - centos , using cpanel , apache , mysql ....
root@server [~]# uname -r
2.6.18-028stab064.7

View Replies!   View Related
Getting Error While Restoring Database.
SQL query:

/*!40000 ALTER TABLE `qhvbmailer_attachments` DISABLE KEYS */;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
UNLOCK TABLES;

--
-- Table structure for table `qhvbmailer_campaigns`
--

DRO' at line 1

View Replies!   View Related
All Website VB On Server Database Error
i transfer all customer in new server

and restore all backups

but all website VB appear Database error

although mysql work very good

View Replies!   View Related
Error On Importing Back-up Database
Quote:

Error

SQL query:

CREATE TABLE `hm2_deposits` (
`id` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`user_id` bigint( 20 ) NOT NULL default '0',
`type_id` bigint( 20 ) NOT NULL default '0',
`deposit_date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_pay_date` datetime NOT NULL default '0000-00-00 00:00:00',
`status` enum( 'on', 'off' ) default 'on',
`q_pays` bigint( 20 ) NOT NULL default '0',
`amount` double( 10, 5 ) NOT NULL default '0.00000',
`actual_amount` double( 10, 5 ) NOT NULL default '0.00000',
`ec` int( 11 ) NOT NULL default '0',
`compound` float( 10, 5 ) default '0.00000',
PRIMARY KEY ( `id` ) ,
KEY `hi1` ( `user_id` ) ,
KEY `hi2` ( `deposit_date` ) ,
KEY `hi3` ( `status` ) ,
KEY `hi4` ( `user_id` , `status` )
) ENGINE = MYISAM AUTO_INCREMENT =538 DEFAULT CHARSET = latin1;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 18

View Replies!   View Related
Error Establishing A Database Connection
Why does this happen? How should I fix it? Can I just restart the sql service? How to do so?

This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at localhost. This could mean your host's database server is down.

* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct hostname?
* Are you sure that the database server is running?

If you're unsure what these terms mean you should probably contact your host.

View Replies!   View Related
Rsync Mysql Database
how can i setup rsync to backup just mysql database (if possible) every 6 hours or so.

View Replies!   View Related
Rebuilding MySQL Database
I have are the .frm, .MYD, .MYI how do I restore/rebuild the database?

View Replies!   View Related
Reloading A Mysql Database
My server admin linked me to this:

[url]

I'm using a cpanel based server, but I can't get this to work.

It requires I be in a directory I figure (this step isnt included)

so I type cd /home/username/public_html/

And then i follow the commands. but it doesnt work.

Basically i need to take a mysql database that I uploaded to my directory, and load it back into a database. :@

View Replies!   View Related
Get Mysql Database From Shell
I have a problem getting mysql to start, so I am planning to setup a new server and move all the mysql databases to a new server.

The problem is I normally get mysql databases when mysql is running by using mysql command lines. Now that I cannot start mysql, I cannot use that method.

Is there a mysql directory that contains all the mysql databases for me to tar it up and untar it on a different? If there is a directory that contains all the mysql databases, do I need to exclude some files/folders so it doesnt conflict with the files/folders on my new mysql server?

View Replies!   View Related
Repait All Database In Mysql
we have whm in my server

in whm is one part to name

Repair Mysql Database

this is only for one database

how may i repaired all database in my server?

View Replies!   View Related
How To Protect Mysql Database
what steps procedures need to be done to keep your database as safe as possible from the hackers. Anyway to be alert when someone got into your db and try to dump, alter your database?

View Replies!   View Related
MySQL With Huge Database
ways to improve the database performance in the situation when I have to modify a large table (several million rows), by e.g. adding a column. Currently this would take several hours which is too slow. The bottleneck is disk I/O. I am considering either partitioning the table over several innodb files on several disks, or going to a RAID-5 or RAID-10, it this will give me better write performance.

The database is 130GB large, and the problem table (which I make period changes to) is the largest table on the server. I cannot have downtime of 3 hours each time I make a change and adding blank fields (to be used later, when a new field is needed) is not an option.

Each time I add a column, the cpu goes into high (80%) io wait state for about 3 hours.

I have a hack which would allow me to split the large table into multiple smaller tables based on some criteria (for example, forumID or such). Here are a couple of things but would like to know which is best, and am open to new ideas. The ideas so far:

1. Split the table into 3 or 5 smaller tables each on it's own disk. The disk IO would then not be so bad, and it might only take 1 hour to perform the table change. But this might not work because the changes to the database (as in adding a column) might be serial, meaning only 1 disk is being written to at a time. (Then again, maybe it will work if I launch 3 different scripts, one to update each table at once).

2. Do RAID 5 or 10, and have 3 or 5 disks. This again might not help at all because of the above issue with MySQL writing serially.

I am using latest MySQL 5.0.45 with InnoDB engine on Debian etch Linux

View Replies!   View Related
Best Server For Mysql Database
Which do you recommend for mysql databases alone? around 200 - 300 connections anytime

I have heard that mySQL alone can be better on 64bit environment. How about the hardware?

View Replies!   View Related
MySQL Database Server In Webmin
I forgot the Password for the MySQL Database Server , How to recover it or change it without Known the old one ..

i have access to the SSH and webmin..

View Replies!   View Related
Optimize All Tables In A MySQL Database
how exactly it helps?

mysqlcheck -o -u...

Like what it does to "optimize" them? Does it really help?

View Replies!   View Related
How To Secure Access To MySQL Database
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 Replies!   View Related
Move My Mysql Database To Another Server
Is it possible to move my mysql database to another server?

View Replies!   View Related
Big Mysql Database 4gb
i been trying to move my server.. But mysql database is quite big and restoring takes ages 10 12 hours.. is there anyway i can make it quick because database dump takes 10 15mins but restore takes 12hours and it should be a way to make that quick

View Replies!   View Related
Which Host For Website With MySQL Database
have just had a website created for me where I can store my photos on. It uses JSP + MySQL for the databse which stores the photo IDs, photo location etc. I want to get it up and running on the net but have no idea how to do this!

View Replies!   View Related
How To Reset Mysql Database Password
i just wanna reset my wordpress database password

View Replies!   View Related
Managed Database Hosting (Mysql)
if there are any recommendations on managed database hosting services. This will be used for a fairly large project running on Mysql DB. Due to the size and complexity of the database a lot of resources are being used, so I prefer to find a company which specializes in dB hosting.

View Replies!   View Related
Mysql Command To Make A New Database
what is SSH command - to make a new database with database name as ( ra_ra ) with database user as ( ra_ra ) and database password as 'ra'

View Replies!   View Related
Does Anyone Have Snort Logging To A Mysql Database
Does anyone have snort logging to a mysql database?

I am trying to get that to work so I can view the alerts with BASE.

I followed the instructions but snort is not logging to the DB,

View Replies!   View Related
How To Back Up Columns In Mysql Database
I have a mysql database, and what I wanna do is to back up specific columns only. For example, I have a table with 2 columns:

City, Zipcode

How can I do that with mysqldump?

View Replies!   View Related
[mySQL] Copy Colomn From 1 Database To Another
I'm trying to copy the contents of a column from 1 database to another. I need to do this as the contents in the current database have got messed up after an upgrade.

The DB structure

table forum_msgs
It contains a column called "topic_id".

Basically I need to copy over the topic ID fields from the "old" database into the "current" database into table forum_msg replacing any values that are currently in the column "topic_id"

I tried this but it doesn't seem to work correctly. Any ideas how it should be done?

insert current.forum_msgs
( topic_id
)
select topic_id
from old.forum_msgs

View Replies!   View Related
Alterntive Way For Downloading A MySQL Database
A friend of mine has an account with a hosting company that recently became unstable and he wants to move his site away.

I downloaded the files, but it now seems impossible to download the databases in the conventional ways.

I tried downloading them using their control panel (vDeck) but I get an error "File Permissions do not allow to download backup".

Then I tried to export it using PHPMyAdmin but the files either doesn't download at all, or it downloads inccomplete with the last lines having something like the following:

Cannot modify header information - headers already sent by (output started at /usr/local/apache/htdocs/phpMyAdmin-2.6.3/export.php:121

I tried to contact their support but they have no clue.

Is there any way to download the database? I thought of creating a script that would manually itterate through the tables and create an export fie similar to what phpMyAdmin creates. I don't know if this is possible, and I hope there are better ways.

View Replies!   View Related
Mysql Database Locations In Cpanel
Does anyone know the default location for databases created through cpanel?

View Replies!   View Related
Backup BIG MySQL Database
What is the recommended method of backing up big MySQL database of size 2 GB ?

Quote:

# mysqldump gallery > gallery.sql
mysqldump: Got error: 1017: Can't find file: './gallery/10tir_user_group.frm' (errno: 24) when using LOCK TABLES
#

I checked the table, it is fine, but can't do the backup.

Quote:

mysql> check table 10tir_user_group;
+-------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+-------+----------+----------+
| gallery.10tir_user_group | check | status | OK |
+-------------------------+-------+----------+----------+
1 row in set (0.07 sec)

mysql>

View Replies!   View Related
Exporting Mysql Database From Helm
i have a fren who wants to transfer a hosting ..for a site made in php and hosted in helm...windows server...

the site uses mysql datbase but i could see no database in the database setting(of helm)...and says no database created..

in host i could see server.mysql in php database config files

i want to export database...to linux server

i have not used helm much..

where actually is database located and how can it be exported?

View Replies!   View Related
MyTop Doesn't Work Anymore Error... Unknow Database...
it works fine for months but now when i type: mytop in SSH i geto erro:

----------------
Cannot connect to MySQL server. Please check the:
* database you specified "test" (default is "test")
* username you specified "root" (default is "root")
* password you specified "" (default is "")
* hostname you specified "localhost" (default is "localhost")
* port you specified "3306" (default is 3306)
* socket you specified "" (default is "")
The options my be specified on the command-line or in a ~/.mytop
config file. See the manual (perldoc mytop) for details.
Here's the exact error from DBI. It might help you debug:
Unknown database 'test'
---------------

I also try to reinstall but nothing...

View Replies!   View Related
Fetch Admin Password From MySQL Database
I have forgot the admin password for one of our application. All the users and passwords are stored in database table "users", is there any way I can get the password from the database.. any MySQL query that will fetch the admin password from that database table.

View Replies!   View Related
Simplest Way To Auto Cron A Mysql Database
I use a php script usually but that does not work for large files.

I have a 130mb mysql database on linux using cPanel.
What is the easiest way to set up say a monthly cron to back this up to the root server?

View Replies!   View Related
Backup Of MySQL Database To A Remote Server
I have a 1GB MySQL database (compresses down to 300MB) and would like an automated method of backing it up to a remote server. Both accounts are shared hosting accounts (if it matters, both are running CPanel, no shell access on either).

View Replies!   View Related
Apache: Load Vhosts From MySQL Database
if it was possible to load vhosts from a MySQL database and the only solutions i found didnt work for me. Im running Apache on Windows. Has anyone seen anything that would work with Windows? The only alternative i can think of is to read the database info using PHP and output it to a vhosts config file. I dont want to do that though because it means restarting the server to load the new config and i hear that a lot of vhosts slows the server down

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved