SQL Server Shuts Down On Logout OS-X 10.4.9
I have managed to get a MySQL Server Running on my G5 Power Mac, however the server only seems to be running when I am logged in. As soon as I log out the Server seems to shut down aswell, although I have set it to run at system startup (with the tickbox in the system pref.).
Is there a way to have the server running in the background as long as the system is up, no matter which user is loged on (or no user just the login screen for that matter)?
View Complete Forum Thread with Replies
Related Forum Messages:
MySQL Shuts Down ...
The mysql server seems to 'shut down' automatically. Im not sure if this shutting down occurs when root logs off the machiene or if its somthing else (perhaps a certian period of server inactivity?) Can anyone tell me what this could be caused by and how to fix it? Here's a further explination of what happens: Last evening I was logged in as root. I noticed that the database server had shut down. I knew this because Im in the process of seting up phpBB2 on the machiene and when I attempted to load the bulliten board's index.php page I got the following error: phpBB : Critical Error Could not connect to the database So I checked in the 'services' panel and in the mysql server section some text indicated that the server had halted. I ensured that the service was checked (so that it starts with the machiene) and then re-started it. Mysql started up fine, and I could sucessfully load phpbb's index.php page again. I loged out of the machiene. Now today, when I attempt to load index.php Im getting the same error msg. Whats going on here?
View Replies !
Mysql Shuts Down Overnight
I got apache 2.0 + MySql 3.23.52 + PHP 4.3.1 on a Redhat 8.0 server. Somehow MySQL automatically shuts down overnight, anyone has a reason for this? Might because of cron?
View Replies !
Sql Error - Shuts Down The Website In 5 Seconds
There is a program called as D4 and it sends a huge data to the sql database and it slows down the website in the first 2-3 seconds and then in a few seconds it shuts down the website until s/he stops using the program. We made a huge research over the internet, but we couldn't find any solutions for this. It can shut down any website, that's having a sql based database. I hope you can help us with this problem. Thank you for your attention and time. if the site admins want to get the program, they can contact us. However, they should be aware that this is a dangerous program so it shoudn't be distrubuted.
View Replies !
Mysql Shuts Down During Rapid Execution Of Querys
I am using version 4.0.12-nt of MySQL and when I hit the enter key rapidly I can't connect to the database. The result is a message is returned to me from mysql that says I can't connect because the database is down. If I only hit the 'enter' key once (to execute the page that my queries are on(their are four queries on this particular web page)) my queries execute just fine. We have noticed that this only happens when we:
View Replies !
Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the site performance is very slow on windows. I dont know the exact reasons. I have seen some benchmark details on internet. But still they are not having concrete facts to support LAMP as a better alternative to WAMP. Allmost all the search done on google melts down to IIS vs Apache, My main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly for PHP/MySQL.
View Replies !
Lost Connection To MySQL Server During Query (LAMP Server)
I recently installed an ubuntu LAMP server for my website and upon trying a script that uses a mysql database (which I set up the tables via phpmyadmin) and I get this error: Warning: mysql_connect(): Lost connection to MySQL server during query in /home/tanner/Desktop/bot/DoctorWho/db_connect.php on line 4 I've searched the forums and I've gotten no answers. Anyone know the answer?
View Replies !
Lost Connection To MySQL Server During Query / Server Has Gone Away
All of a sudden the server stopped working. When trying to execute a simple INSERT both from PHP and Query Browser, the server crashes and I get either "Lost connection to MySQL server during query" or "Server has gone away" errors. The problem started on 5.0.18, and upgrading to 5.0.41 didn't help. I'm using Windows XP SP2. I've seen quite a few posts on similar problems, but no real solutions though. Is that a bug?
View Replies !
Mysqldump From Server To Server OR Move Folder /var/lib/mysql?
I need to move db's from a live server to a new server. The new server will be replacing the existing server once it's setup, and I need to move the DBs in order to do the testing. My question is this; if I use mysqldump to get a dump of all the DBs on the existing old server, and then import that .sql file to the new server, will that copy over *EVERYTHING* i need to get the DBs working again? Privilages etc ? The alternative that I am considering is to move the /var/lib/mysql folder along with mysql.cnf. That should work, as we can change any locations in the mysql.cnf file, but it does mean taking the server offline while we tar the databases, which could take 30 mins or so.
View Replies !
How Do You Manage Changes From Development Server To Production Server?
What started out as a simple test of mysql has turned into what is quickly becoming a replacement for our entire business system and web site The bad news is that we are now wrestling with how to we continue working on development the system without risking down time for users. If we work on a development server, how can we log the changes to table structure and then apply them to the live database on the production server when we are done testing? Is there some sort of tool or log that would just let us apply table structure changes to another copy of the database?
View Replies !
Access Denied For User From Server A To Server B
I'm trying to connect from Server_A to a db on a separate server, Server_B. I granted privileges to 'user' on Server_B using the following syntax: GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; But, it still yields this message on Server_A: Warning: mysql_connect(): Access denied for user: 'user@111.111.111.111' (Using password: YES) I verified that the password is correct, and I also flushed privileges after executing the above command.
View Replies !
Ugrading Win2k Server To Win2k3 Server
I would like to know if there is anything I should watch out for or do before I upgrade my Win2k server to Win2k3 server. I am running MYSQL version 5.0.27 and PHP 4. Which I must admit was a bit of a challenge finding the right combinations of the 2 that work together very well for my setup.
View Replies !
SQL Server 2000 To MySQL Server
I'm trying to do an export from an SQL Server 2000 Database to and ODBC driver pointed to a mySQL Server Database. The export works if there is at least one record in the mySQL table. If the mySQL table is empty it gives an error that looks like this: Insert error, column 1 ('field1', DBTYPE_STR), status 6: Data overflow. The strange part is that the export works perfectly fine as long as there is one record in the mySQL table, if there are no records in the table, I get the error above.
View Replies !
Mysql Server And Regular Server
I recently decided to get another server to do just mysql, however, I ran into a few problems. As soon as I switch the script to pull from the other server it creates a huge lag between the two and eventually starts timing out the sites. in my.cnf i did do skip-name-resolve but still the same thing. Are there any programs or anything that are maybe bottlenecking it because the site will load in the first 10 secs after i switch the mysql (with a lag) but that lag gets bigger and bigger. The mysql error log doesn't show anything weird either. To further complicate things, another server that was pulling off it worked for the first few hours, then when traffic started to increase, it started doing the exact same thing. (both server loads were low and max connections was not getting even close). Roughly 600 qps, half to HEAP tables.
View Replies !
Mysql Server On A Remote Server
I have recently installed a mysql server on a remote server machine. It has 197.0.3.57 ip address assigned to it, and i believe the port it is using is 3306. I have also installed a mysql command line client on my PC, and successfully launched it. Now i have: Enter password: But how do i get connected with the remote mysql server, it seems the system is asking me to enter localhost password. What sort of client package shall i install other than commnad line client if any? and what command shall i invoke to get me connected?
View Replies !
Web Server Ram
How do I calculate the memory needed by a webserver (APACHE) connecting to a mysql server (different box). Is this only related to the select() operations / data transferred to the webserver? On the mysql server I assume that I have to calculate the max tabel size X the number of connections.. but I'm not sure about the web server size.
View Replies !
Different Server
we have a client who we're designing a website for and we have a shared server so we thought we'd just host it there but we DON'T want to handle their email so I'm assuming this means they're going to have to stick with their current host right? Well ok, but we want to make use of a MySQL database but this would sit on OUR server...so how do I go about this? Couldn't I just replace the 'localhost' with 'someipaddress/whereeverthedblives' or something like that? The only other thing I can think to do is to have the specific page that holds the db information actually live on our server, but look like it's living on the same server as everything else.... I'm not even sure that would work....but regardless, I don't know which way to go.
View Replies !
Server
My MySQL server is accessible only through the socket file (I believe). netstat -lan yields: cac1bc82 stream 0 0 c1e37378 0 0 0 /tmp/mysql.sock I can't figure out how to get mysql to listen on 3306. I would like MySQL to listen on 3306 automatically upon boot. I have gone to mysql.com and have tried everything i can find there.
View Replies !
Server A To Server B
I am a web master who up until about a month ago had only worked in ASP using Acess Databases. Now I have a client (in Austria) who I redid his web site using PHP and a mySQL database. To access the his db, I browse to a web site, log in, then manipulate the database that way. I just set up a new hosting account in America and am baffled at how I transfer the database from the current server to the new one? Do I somehow export and import the database? Is there a file created so to speak?
View Replies !
On A Different Server
I need to know how do I place my databases on a different server on a different machine(a very remote machine.). Are there some files that I can just place in some particular directories?
View Replies !
UDF Server 4.* 5.*
I noticed that behavior of "create function" depends on server version. Using connection with empty database name In early versions we do not need to write database name befor function name, but in 5.* we MUST write some, eaven if we realy don't have such database. Question is: Am I right? and From whoch version such behavior appeared.
View Replies !
Do I Need A Server?
Our company is considering putting our work order and invoicing systems on-line. We are thinking a MYSQL/PHP development and install would be a good fit. My boss, the owner of our company, mentioned this to the computer tech that services our hardward. He told my boss this idea is a very poor choice and one of his reasons was we would have to purchase a $4,000 server to run a database. Currently we are using an Access data base with Visual Basic, I've done all the programming. The size is approx. 107,000 KB, a very small data base. Also I've already built a small MySQL data base on my home computer with no problems. Can someone explain what exactly we will need as far as front end hardware to accomplish our goal? Do we need a server? Anything else?
View Replies !
Server Name
I have MySQL installed at www.mydomain.com/phpdirectory/ I have a php application that needs to connect to a database I created and it is asking for the database server name. When I log into MySQL admin panel it says Server: mysql via TCP/IP. When I click on "Databases", at the top of the screen it says "Server: mysql".
View Replies !
Best Server
Could anyone answer my questions : 1. Can VB applications on Windows clients (workgroup) access MySQL on a dedicated Linux server ? If Yes, could you tell me how to set the network for it ? 2. If my application should run from a windows client, using MySQL, Which server is the best ( speed,stability, ease of opration and cost ) for running the database : a. Dedicated Windows server 2002 b. Dedicated Windows XP
View Replies !
How Do I Set Up The Server?
I have tried installing both MySQL and DBDesigner4 but am confounded by the request to sign in - Invalid Username / Password So, can anybody tell me how to set up the program so that I can start working with a database? Are there online manuals anywhere?
View Replies !
My Sql Server 5
I'm trying to connect to a Win XP instalation of Server 5, from a win 98 PC over our working LAN. The PC's can ping each other and can browse files on each other. I can connect to the sever from the XP PC, under MySQL and ODBC. The Win 98 PC has the ODBC 3.51 connector installed. I can't even get the DSN to connect un the the Create Data Sources.
View Replies !
SQL Server
I have used PHPMyAdmin and MySQLFront for connection to MySQL to create and manage tables. What tools would I use to connect to a MS SQL Server Database?
View Replies !
Replication On Only One Server
I am searching on documentation and on web and on groups but I can't find an answer to my question: I want to use replication from one database on one server to onother database on the same server. Is it possibile? The only information I found is that it is possible if you setup 2 servers on the same machine but I don't want to do so. Is there another way to do it? Or maybe someone has a suggestion to solve my problem?
View Replies !
SERVER From Pid File
we installed a mysql vr standard-4.11.22a-pc on a machine with ubuntu breezy badger as os..after the installation we are trying to start the server by typing :bin/safe_mysqld...but it shows us a msg whch states Starting mysqld daemon with databases from /usr/local/mysql- standard-4.11.22a-pc-linux-gnu-i686-glibc23/data followed by... 'STOPPING SERVER from pid file /usr/local/mysql-standard-4.11.22a-pc- linux-gnu-i686-glibc23/data/linuxserver.pid mysql ended' i have used the chown command already (chown -R mysql data)...but it still doesn't solved the problem.. to summarized : all subfolders within the mysql directory->bin, lib, man, mysql- test, etc, etc is owned by user root except for the DATA folder w/c is owned by mysql user.
View Replies !
Server Doesn't Take All Options Out Of My.cnf
------_=_NextPart_001_01C34C58.52CDCBE2 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable My problem is, that all variables except "wait_timeout" are initialized from the my.cnf file, only "wait_timeout" is always set to the standard value... Has anyone the same problem? Does somebody know how to resolve it? =20 Moritz =20 ------_=_NextPart_001_01C34C58.52CDCBE2--
View Replies !
Server-Client
I coded a program by using VB 6.0 I will use this program on network(nearly 12 user). is it necessary to code two different program for both of server and client. Or, Can I solve this problem by MYSQL Control Center.
View Replies !
Fw: Server-Client
I think that I should ask the question like that. I want to run MySQL on 14 client. What am I do. I try but There is a problem that i can't find.
View Replies !
Restart Server?
how do you restart the mysql server? It¹s already running, I just want to stop and restart. I spent 30 minutes searching the manual and couldn¹t figure it out. I eventually just rebooted my server.
View Replies !
Moving DB To Another Server
I am moving a web site with a MySql database to another server. Can I create a database on the new server with the same name and then move the tables there, or is life not that simple? Or can I create tables with no data and then replace them with the files from the other server? I know I can export them as text files and them import them, but that is a lot of trouble. Also, using my FTP program I can't access the mysql folder on the server, but I can using SSH as the root user. If I can indeed just move the table files, can I FTP to another folder then use the mv command in SSH to move them, or will I run into permissions problems there too?
View Replies !
IBM XSeries Server
We are upgrading from an overworked compaq linux box to possibly an IBM xSeries 445 server. Running RH/MySQL3.23 (soon 4.1). Anyone running one of these and is it any good? The DB is busy - about 300 (up to 700) concurrent connections serving a busy portal type site. IBM are trying to convince us to run the web server (apache), and java server on the same box (theyre separate now) - but we have our doubts that they can all sit together happily on the same machine with this level of load. Do many sites run MySQL and Apache on the same box, and is it recommended?
View Replies !
Database Server
I have installed MySQL on WinXP Pro When attempting to access various commands from the command prompt (eg help, set password etc) I get the following error. ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) When trying to access the MySQL server via a local web page I am also unable to connect to the database. I have successfully installed Apache 2.0.35-win32-x8 and PHP. Appreciate any suggestions for what may be the problem here. Also how do I import databases and their records from a previous install on another computer?
View Replies !
Logging Into Server
I have a linux box with MySQL. The following fails. If I try to login locally using mysql -u USERNAME -p If I go to another computer on the network and try using the same user name and password by: mysql -h SERVER ADDRESS -u USERNAME -p This login is successful.Does anyone know why the first operation fails?
View Replies !
Data From SQL Server
How do I get data from my tables in SQL Server into my tables in mySQL I have tried exporting the data out of SQL Server to a flat file (.txt), and then import into the table in mySQL from the txt. For some reason, it bombs and closes my GUI (mySQL control center)
View Replies !
How To Find Server
i have installed sql server management studio express but there is a problem when I open it. it says no server connection. so i don't know how to make my pc a server. would u please tell me the process to make pc a server for sql server 2005.
View Replies !
Server Timezone
The web server my site is hosted on is on the East Coast, and I'm located here on the West Coast. How can I subtract 3 hours from the string below, which uses the server's timezone? PHP Code: $Adate = "Date_Format(Current_Timestamp, '%a %b %e, %Y %h:%i %p')"; I've read that INTERVAL has something to do with it.
View Replies !
Server Error
Error i get: Can't connect to local MySQL server through socket '' I am attempting to conect to my mysql database, through a program i'm writing using mysql++.The database is running and my website(also using database) is recieving no problems. I notice in the error that it can't connect to socket '' which is the empty string which is wierd, looking for solutions on the net gave me plenty of results with the socket being '/tmp/mysql.tmp' or the like, but none with it empty.
View Replies !
|
TRACKER
