Configuring A New Server
while configuring a new server instance the following error message is throwed:
" The template configuration file cannot be found at C:programFilesMySQLMySQL Server 4.1inmy-templates.cnf "
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Configuring Database Server
tell me a way to increase the productivity of a database server. It has nothing else installed other than the newest production version of mysql and the default packages from FreeBSD. Is there a toaster than can bring me up to speed.
Configuring A Database On A Remote Server
i have an aplication on .net for web, with mysql db, in my local server i have no problems, but recently i upload the aplication into a bougt host; when i open the page on the internet explorer or firefox, the page loads well, except for one simple grid. in another part of the aplication i try to insert a record, the app gave the me no error message, but when i check the table, there's nothing new. i don't if i configuring something wrone, on the web.config. and the worse of all if that i dont get any error?
Configuring MySQL On Mac OS X
I recently tried to install MySQL on Mac OS X box using these instructions on the Mac site (http://developer.apple.com/internet/macosx/osdb.html). All was working fine until I got to this part here: ./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/run/mysql_socket --with-mysqld-user=mysql --with-comment --with-debug I got a bunch of "file not found" errors so I wanna trash whatever I did and start from scratch, but I don't know what exactly to delete? Does anyone have an idea about this?
Configuring MyODBC
I am using MyODBC 3.51 with Borland BDE, and was having a problem whereby Blob result fields were being restricted to a maximum size of 32k. Now, in the BDE control panel, I can set configuration variables for the MyODBC driver, and I was able to change the value of BLOB SIZE from 32 to 128, which solved the problem. However, there are many other configuration variables there (TRACE MODE, BATCH COUNT, BLOBS TO CACHE, ENABLE SCHEMA CACHE, ROWSET SIZE, etc.) for which I have not been able to find any documentation. Does anybody know where I can find documentation for these settings?
Configuring MySQL
I have WindowsXP Proff. O/S. And I have installed mySQL ver 5.0.1 I have also installed php and Apache in it. Now I want to configure it with Apache, PHP and I also want to configure with phpMyAdmin. so I can use it comfortabley. So does anyone have an documentation of it?
Configuring PHP And MySQL
I've installed Apache 2.0.59 [ C:Program FilesApache GroupApache2 ] and PHP 5.1.6 [C:PHP] successfully. I've tried test page also it works. I've also installed MySQL 5.0.24a successfully. But i couldn't connect PHP file with MySQL database. I've searched in google too but not getting please write for me or suggest me the best website which describe the installation process of the version i've mentioned above.
Configuring On Win98
Win98 , Apache 2.0, Apache running on port 443 is that matters. Latest version (community) of mysql, 5 i think. Have run the msi file and installed mysql. Wasn't promted for a username / password during this , not sure if thats right, maybe only on win2000/xp? I'm stuck as what to do next. cd'ed to mysql....in and ran mysql.exe and gives me the error, cant connect to mysql server on localhost 10061.
Configuring MYSQL 5.0
I downloaded MYSQL 5.0 and tried to configure it but I do get the message "Could not start service MYSQL : Error :0". if anyone can advice me what do or where to seek information to correct the problem.
Configuring The Service In Each Start Up?
A couple of weeks ago I posted several questions in one post, and I think I overwhelmed people, so I'm breaking it into individual questions this time. I don't know why but everytime I use MySQL I need to reconfigure the server using the wizard(I go to start>programs>mysql>MySQL server 4.1>MySQL service instance config wizard) everytime I turn my computer on. If I don't, I get a "ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)" error when trying to connect to the server in any account. I don't have to change anything when I run the wizard, I just click next all the way, and when its done I can connect normally. I've noticed that at the end of the configuration when its running through all the tasks, the last one says "Sart service". I'm guessing that I'm not starting the mysql service when I turn my computer on, and that reconfiguring the service solves the problem because it starts the service for me. Do I have to reconfigure the service everytime I want to use it? Is there another way or maybe start the service automatically?
Installing And Configuring MySQL
System: MAC 10.3.2 G4 workstation For the past three weeks I am trying to do the "simple" install. But of course it never works the way it reads. I have followed the FAQ and install descriptions that came with the package <http://www.mysql.com/doc/en/Mac_OS_X_installation.html> but i am stuck. At the moment I need to create a database and set the root password. i have no idea why it is not working. the following is the command line and error I am getting. Can someone please help me to install this properly?
Error Configuring Mysql?
I have installed MySQL CE 5.0, but during the configuration wizard I get an error. It has frozen up during the final step (MySQL Server Instance Configuration). I'm installing it on Windows XP, and I used all the default settings, except that I changed "Detailed Configuration" to "Standard Configuration". At the "Start Service" item in the checklist, I got a 1045 error message saying to allow TCP port 3306. I tried creating a rule for this in Norton, but it didn't seem to work. So then I turned off Norton completely, restarted, tried the wizard, and now it puts a red 'x' in the "Start service" checklist and says "The service could not be stopped. Error: 0". So I don't know if this is really a Norton/firewall issue or not. I can't seem to get around this final step.
Configuring MySQL For JDBC ?
I'm having a MySQL DB running on one machine and a Java-Tool which accesses this DB via JDBC. With this tool, I can add a second DB data source in form of a mySQL DB and I've installed one more MySQL DB on a third machine, which runs perfect, but the access from the java-tool via JDBC-connection doesn't work. Command line "mysql" tool work perfect from the machine where the java tool is running. The company which coded the java-tool told me that I have to install a package for the mysql db which enables jdbc. Is that right and what do I have to configure ?
Configuring/Setting Up MySQL 5
Im a complete newbie to mac os x. I downloaded and installed mySQL 5. I installed it and now i cant seem to connect. I have absolutely no idea what im doing. Im not familiar with os x termial commands. I need someone to email me and explain to me everything i need to do in order to create a user and successfully login using mySQL admin. I've been struggling with this for over a week. Ready to pull my hair out. And please dont refer me to online resources, ive read them all and still cant figure it out. I need a professional who can give me a step by step process to get this going.
Configuring XAMPP In The Domain
I am installing my XAMPP in my pc. It works fine. Everything works. My question is, is it possible to install XAMPP inside in my domain e.g., www.mydomain.com/xampp. Please help me to configure it using the domain, not in the localhost.
Error Configuring PhpMyAdmin
I'm trying to install phpMyAdmin on a test server. I am using the GUI to create the configuration script.I would like to use HTTP mothod for authentication. As the guide says, I need to create a user and grant some privileges to the user. Here is the problem. mysql -u root -p INSERT INTO `user` (Host, User, Password) VALUES('localhost','pma',PASSWORD('something')); Next I try to grant privileges, but receive an error: GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'something'; Error 1133 (42000) Can't find any matching row in the user table. Now I know the user is there...If I do SELECT * FROM `user` WHERE User='pma'; I get results, 1 row in set. The password is encrypted, but I did double check with the original user creation line and it is the same and typed in correctly. localhost is also there.So why is it not finding any user when I want to grant privileges?
Configuring MySQL With Tomcat
I'm trying to configure Tomcat 4.0.1 with mySQL 1.3. I have copied the mySQL driver (mm.mysql-2.0.8-bin.jar) into tomcat/common/lib but I can't get a connection with the database. I can see the database and tables when I use the GUI for mySQL (winmysqladmin.exe). I'm running Win2K and java 2sdk1.4.1_06.
Configuring Script For Mbstring And Pconnect
i was told i need to "configure your script to use pconnect (persistent connections) to the mysql database.". because "Your site is creating too many concurrent connections (20 is a reasonable limit).". as well i need to figure out how to add the mbstring function on mysql, so that my pages with special characters (french characters), will load up properly.
Configuring MYSQL Enterprise Monitor
I was given the setup files for configuring the MYSQL Enterprise Monitor with dashboard for testing in Local. 1. I have installed MYSQL Server to my localhost [Windows]. MYSQL SERVER Version: 5.0.50sp1a-enterprise-gpl-nt. 2. I have installed the MYSQL Network Monitor to my local system [Windows] With all options like admin login, agent and other details. But my doubt is how to set my MYSQL DB Server for regular monitoring using the MYSQL Enterprise Monitor. I.e I just want to know about the Server setting like how to add my localhost server to the Mysql Enterprise Monitor. We have a Enterprise Subscription but as iam just a developer i dont have the login id so can i get help from here?
Software Rollout: Configuring Mysql Driver
When rolling out software that uses a mysql backend, how is it possible to configure the odbc driver for mysql during the installation process of the software? Is there anyway to do this via command line, installshield, batch files..? What would one do if individuals were not "computer literate", and would not how to go about setting up the driver themselves or to make it easier, the software would automatically do it for them?
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.
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?
Connect From Unix Mysql Server To Ms Access Server
Im wondering is it possible to connect through my mysql db (running on fedora core 4) and access the ms access tables on the ms access server? I have a connection setup the other way around using an odbc bridge, is it possible to do this the other way around enabling me to view / edit the access tables through mysql.
Copy Data From Database On Server A To One On Server B
In an older version of MySQL that defaulted to MyISAM table types I could simply copy the contents of the MySQL/Data/DbName folder to a similar folder on another server and the MySQL on that server would, following a reboot, see the entire database. Using the 4.1.12 version of MySQL the default is InnoDB tables ( and I do want to move to transaction save tables anyway ) - which do not respond to the same treatment. How can I copy and entire database from one server to another ( this new server is at a different site, connected over the VPN ) Both servers are running MySQL 4.1.12 on a Windoz operating system.
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?
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.
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.
Server To Server Root Prob
Not to sure if this is the correct forum for my problem, but here it is. I have a site running mySQL and the hosting I would like to keep but is in another country, not UK where I am based. I have a domain hosted on another server which I would like to use as the main site domain and is a .co.uk which I belive has to be hosted in the UK. Now when I use the UK domain and link to my overseas SQL data base it changes the path eg /home/www.myurl.com/index.html/..... the /home/ is the problem which causes errors when the database is called..etc.
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.
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?
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?
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.
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.
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?
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.
Server
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.
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
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.
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?
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.
Moving From One Server To Many
First off Ive never really worked with databases that have been spread out amongst many servers. However I am currently working on a project where we are considering doing so sometime in the near future (in the next 6 to 12 months). So at the moment I really want to investigate how this would be done so I can start planning for this. The project is mainly done in PHP (however I have written a few C extensions to boost the efficiency of some routines). Anyway, I'm just wondering how one goes about doing this. We are thinking of breaking the database up amongst four or five servers to spread out the load. Also, is it possible to do a query that joins tables that are located on multiple servers or would these need to be done as separate queries?
What Not To Do On A Production Server!
So I experienced a hard lesson last night (I can't say learn because I don't know the proper way to handle it in the future). While trying to speed up a large table (5-700,000 rows), I basically killed our server. I was re-indexing the columns so that the most used queries would benefit some more, but I obviously did something wrong. I dropped what used to be a compound index to put the index on a single column, but in doing so, the entire MySQL server was tied up! While this was tied up, other queries queued up, and what resulted was a server nightmare. In the end, after waiting and trying and waiting some more, the server was more or less unusable for over an hour until we took some initiative and restarted the MySQL service on our box. I would still like to get into the server and finish re-indexing the tables, but we can't go through another fiasco like that. What is the proper way to handle large tables like this on a production machine? I tested the steps on our development databases (which were much smaller unfortunately) and no problems at all. I'm sure there is a proper way to do this, but I am not sure what it would be.
Where Is Mysql.server
CentOS 4.4 amd64 I'm following; Virtual Users With Postfix, PostfixAdmin, Courier, Mailscanner, ClamAV On CentOS http://www.howtoforge.com/virtual_us...amav_centos_p4 to build the server. Coming to P-4 # /etc/init.d/mysql.server start bash: /etc/init.d/mysql.server: No such file or directory # /etc/init.d/mysqld status mysqld (pid 3164) is running... MySQL is running. At the bottom of P-4 CentOS manner: /etc/init.d/mysql.server start /etc/init.d/saslauthd start /etc/init.d/courier-authlib start /etc/init.d/courier-imap start /etc/init.d/postfix start The other 4 commands worked without problem
MySQL On A FTP Server
How can I install MySQL on a Server that I have FTP access to? It seems that I can only install it on a local hard drive.
IP Address Of The Server
I would like to find the MAC address of the MySQL database server as the result of a query, by using a "select" statement. Is that possible?
Query For Server Name
I am running a mysql cluster with several API nodes. I just setup load balancing and getting ready to do some tests. I want to run a query for something like servername on a loop and see if my load balancer is sending every other query to different API nodes. Is there a select statement I can use to find out the server name?
GO Keyword From SQL Server
In SQL Server I can use GO between statements to execute multiple statements in the query window. What is the mysql equivalent?
|
TRACKER
