How To Force To Read The My.ini File In Windows - While Starting The Server
I have my my.ini inside the c: in windows 2000 and while starting the
MySQL server (4.0.20), none of the variables declared in that file is
getting reflected ...
Is there any way to make the server to read it by forcing.?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
How Do I Read The Log-bin File?
Does anyone know how to read the binary log from a client workstation? The log is named hostname-bin.001 and when I open the file it is unreadable (obviously because it is in binary). So making a shortcut to that file will not do the trick. How can I open the file via a mysql command prompt on a client PC?
Read The .err File
Working on installation in Mac OSX 10.4. Need to read the .err file, but don't know how to find it. If you can help, please show the path from from the 'top' i.e. /usr/local/mysql/ and the rest of the path.
Read In A .sql File
I have a large SQL file that contains a bunch of create table statements.How do I get mysql to read in this file and process the sql. =20.I am not thinking load data infile because it isn't text
Can SQL Read From A File Or List
I'd like to do a select statement that would substitute variables from a file containing a list of strings, or a list of strings right on the command line. Here's my pseudo code: SELECT {some value from my list, table or whatever} FROM {some list of tables in a file or other table etc}..
How To Read A File Into Mysql
i have created a output file from oracle which contains insert statements like insert into tms.tms_rem_exclusion_list values (3337) insert into tms.tms_rem_exclusion_list values (4175) insert into tms.tms_rem_exclusion_list values (4227) iam new to mysql and someone told me that if i create such a file i can import this data into the mysql table at the mysql prompt like mysql> tms_rem_exclusion_list < test.sql; (name of the above file) but iam getting this: ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'tms_rem_excl usion_list < test.sql' at line 1 first of all i am not sure where to keep the test.sql file ie in which directory so i kept it under the scripts folder.
Read Back Up File
I got this error. shell> mysql -e "source /var/lib/mysql/test.sql" backuptest ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'backuptest'
Read Text From A File
I have a text file which contains the following data 1&david&0248814&software engg&1973 2&thomas&8475623&commerse&1965 I have created a table <info> with the attributes nr name reg_nr sub born_yr I need to somehow read the data from the file n insert them into the table attributes... does anyone over here know how could this be done ? to insert the data to the table could be done with insert into <table> values <value> but the problem is how can i read it from the file...leaving the '&' sign ?
Starting The Server
I've had my Instance starting whenever I startup my computer, which was working fine, until now. Every time I try to start it from the MySQL Administrator. I've tried to start the sertvice and It just goes right back to stopped and gived the log message, "Trying to start the server ... Server could not be started." How can I start the instance or find out what's going wrong?
Read Mysql Dump File?
I am trying to read a mysql dump file that I was given from a mysql dump file into my mysql server, I am using the following command at the mysql command line and get the following error: mysql> items < c:ookingsitems.mtsql ERROR: Unknown command ''. ERROR: Unknown command 'i'. Does anyone know what this means?
Read Mysql Dump File?
I am trying to read a mysql dump file that I was given from a mysql dump file into my mysql server, I am using the following command at the mysql command line and get the following error: mysql> items < c:ookingsitems.mtsql ERROR: Unknown command ''. ERROR: Unknown command 'i'. Does anyone know what this means?
Mysql Server Not Starting
I installed mysql on a Mac OSX 1.3.9. It worked and ran with no problems. The machine was restarted and mysql will no longer start up. I have tried everything and nothing works. If I look at the logs it basically tells me that mysql starts and then shuts itself off.
Starting Mysql Server
I installed mysql with apache but after a while mysql stoped starting. I even reinstalled both mysql and apache but still i can not start mysql. could any one tell me how to fix this problem.
Trouble Starting Server
I have no experience with mySQL whatsoever and I just installed it on my linux box using the documentation on the mySQL site. When I used the command: bin/mysqld_safe --user=mysql & to start the server it gives me the following message before stopping the server: [2] 4105 [1] Done bin/mysqld_safe --user=mysql [root@weston mysql]# Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070205 18:38:15 mysqld ended
Starting MySQL 5.0.1 Server Up Problem...
I shutdown my MySQL server using MySQL Administrator 1.0. My problem is that i dont know how to start up the MySQL Server again. I tried to run mysqld-nt.exe by double clicking it but my server will not be up. If i restart my computer then thats the time my MySQL server will be up. Unlike MySQL 4.0.22 if i double click on winmysqladmin.exe my server will be up. Is there a way to put the server up without restarting my computer?
Mysql Not Starting After VPS Server Reboot
I have a mysql db (Version: '4.0.22' FreeBSD port: mysql-server-4.0.22) running on an Verio VPS, and I am having an issue: After a power failure on Verio that meant restarted servers, etc, I saw that Mysql was not coming up. I checked the logs / etc and I got this message on /var/db/mysql/<hostname>.err: 060925 00:15:53 mysqld started 060925 0:15:53 bdb: Recovery function for LSN 1 29049 failed 060925 0:15:53 bdb: warning: ./testperl/testab.db: No such file or directory mysqld in free(): warning: chunk is already free 060925 0:15:53 Can't init databases 060925 0:15:53 Aborting There is no ./testperl/testab.db anywhere I can see, but OTOH, there should only be a few dbs and none of them is called testperl... Honestly, I have no idea of what might be hapening, but having the db is quite a PITA.
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 Socket Error On Read. WSAGetLastError Return 10054($2746)
We just migrated our MySQL database from a NetWare server running version 5.0.21 to a openSUSE box running version 5.0.45. Everything ran fine for a couple of days, then clients began losing their connections and creating new ones without the old threads being terminated. This behavior is the same for the Delphi client we use to access our database as well as the MySQL Administrator tool. I've tried adjusting connection_timeout, but overall the settings for this server are the same as the previous one that ran without issues for a year.
Load File Using Backslash Ok In Windows?
I use mySQL 5.0.6, windows xp pro 2 I have a questions: I type something like this: LOAD DATA INFILE “d:Doctor.txt” INTO TABLE Doctor LINES TERMINATED BY “ ”; I use backslash "" and it is Working. Is it OK? because I thought we have to use "/"
Can't Create/write To File In C:windows
I installed the 3.51 ODBC driver on a new test machine that is re-imaged each night to a clean OS (Win XP Pro SP2). We place our developer daily builds on this machine and run some automation. In the automation process, MYSQL statements are ran. The issue I get is that sometimes it stops with this error: "Can't create/write to file 'C:WINDOWSTEMP#sql_1808_0.MYD' (Errcode: 13), #-2147217871" or it will run right away, or sometimes it takes 3 tries before it finally gets past whatever it is choking on. I do not have MYSQL installed on that machine, only the driver. I have given the "Everyone" account full permissions, but still no luck. Any suggestions? The environment variable on the machine is set to C:WindowsTemp and it appears to execute some statements before, just is stops on some.
How To Execute A Batch Sql File Under Windows?
I have installed MySQL 5 in c:Program FilesMysql. I have a sql file named "books.sql" which is put in the subfolder in,it contains many statements that like "INSERT ... value ...". my question is how to execute it? I try it, but failed. One more question is how can I return from "->" to "sql>" promopt?
Sheduled Mysqldump Via Windows Bat File
I want to make a scheduled task in windows to do a mysqldump. Someone gave me this .bat to run but I'm not able to get it to work. REM @echo off for /f "tokens=1" %%i in ('date /t') do set DATE_DOW=%%i for /f "tokens=2" %%i in ('date /t') do set DATE_DAY=%%i for /f %%i in ('echo %date_day:/=-%') do set DATE_DAY=%%i for /f %%i in ('time /t') do set DATE_TIME=%%i for /f %%i in ('echo %date_time::=-%') do set DATE_TIME=%%i C:Program FilesMySQLMySQL Server 4.1in mysqldump -u user -p'pass' dbname >C:DATE_DAY%_%DATE_TIME%_database.sql When I run this script it doesn't work. All I get is a blank .sql file in the output directory.
Connecting To A Server From Windows XP
I have installed MySql 4.1 on my windows XP home computer. I would like to connect to my university's server, but when I start the program, it automatically asks me the password, then connects me to my own home server. How can I connect to the other server?
Windows Mail Server
I'm curious what mail server is reccommended for interaction with mysql on windows. Our basic requirement is to have the mail client send e-mails based on addresses in the db (not spamming - for password resets, etc).
Windows To Linux Server
I am trying to set up a a Mysql driver on a linux server from a windows machine. I get the following error. [MySQL][ODBC 3.51 Driver]Host '(server number)' is not allowed to connect to this MySQL server Is it likely that the windows-linux combination is causing a problem here?
MySQL Server For Windows
I have Windows-2000 Server with IIS-5.0, PHP (4.3.0) and MySQL (3.23.55). There are about 4000 users with their MySQL databases. Users can access databases using their PHP scripts. Only local users are allowed. To create a user I use this command: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `User_database` . * TO 'User'@'localhost' IDENTIFIED BY 'Pass'; The problem: after 3-4 hours of work, all users getting the error message: "Can't connect to MySQL database at localhost (10061)". I can't connect to MySQL using mysql.exe with admin username and password too! But MySQL service is still running! Restarting of MySQL service gives no result. Restarting of IIS gives no result. Code:
Importing Large Dump File Into Mysql On Windows
I have a 80 meg dump file created with mysqldump. I need to import it into a mysql db on Windows. On linux, I say "shell>mysql dbname < dumpfilename" But that does not work on Windows. Importing via phpmyadmin is not possible either since we are limited to 2 Meg file size.
MySQL On Windows Server 2003
Is it a good idea to use MySQL on Windows Server 2003 as a good alternate than Microsoft's SQL Server? I've never used MySQL before, could someone tell me how close it is to SQL?
MySQL On Windows 2000 Server
I want to install MySQL on to a Windows 2000 Server, I also want to remotely manage it using MySQL administrator, so connecting to the server using its IP Adderss, On windows workstations if you try and connect to the MySQL database from a remote mechine it does not allow you to do it (I have disabled all firewall's etc.). Do you have to install a server version and not LOCAL version of the MySQL server?
Installing Mysql On Windows Server 2003
i have installed mysql 5 on windows server 2003 and when i want to connect to the database throgh my script it gave me this error Warning: mysql_pconnect() [function.mysql-pconnect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:Inetpubwwwroot estdefault.php on line 9 Couldn't connect to server. why it is like this. what i have to do and also i can access the database from Mysql command line client....
Remotely Connecting On Windows Server 2003
This is probably answered somewhere but I can't find it. I have MySql 5.0 installed on a Windows Server 2003 box and it's working fine. I can connect to it via MySqlAdministrator, MySqlFront and Helm Control Panel which are all installed on the same box. When I try to connect via a remote machine I get an access denied error. What can I do to connect remotely?
MySQL Installation On Windows 2003 Server
I recently downloaded mysql-4.0.18-win.zip and my plans were to install it on my Windows 2003 Server. After unpacking the files, and clicking on Setup.exe, I get the following errormessage: "C:WINDOWSSYSTEM32CONFIG.NT. The system file is not suitable for running MS-DOS and Microsoft Windows applications. Choose 'Close' to terminate application."
MySQL Service Keeps Shutting Down In Windows Server
Strange, MySQL has been running smoothly for almost a year on this server, and just recently it shuts down after boot up. Running Windows 2003 with all patches. Any attempts to restart MySQL results in shutdown of the service. This is the Event error message: "TCP/IP, --shared-memory, or --named-pipe should be configured on NT OS" Here is the log that shows the shutdown... Code:
How Do I Start Logging On Windows Live MySQL Server?
As I understand it, the server has to be shut down for the logging to be successfully started. Is this correct? I have been experimenting on a local MySQL server to make sure I know what to do on the production server. My production server has a my.ini file at the location c:Program FilesMySQLMySQL Server 4.1my.ini with various config stuff in it. Would it be ok for me to add the following under the [mysqld] part of the file: log=/logs/mysqld.log Thus creating a file named 'mysqld.log' in the folder 'logs'. The main things I need to log are the SQL Statements being executed and the IP Addresses/hostname of the connections. What type of log would be best for this? Also how do I make it so that the log doesn't grow ridiculously large?
MyODBC Error On Windows Server 2003 - Unable To Set Up DSN
I recently installed MySQL on my Windows Server 2003 and got to know that one needs MyODBC also, in order to make ASP webpages able to access the MySQL database. Now, here is my problem. I installed MyODBC-3.51.06.exe on my server. The installation went OK. But when I want to make a User DSN or System DSN i get the following errormessage: "The setup routines for the MySQL ODBC 3.51 Driver ODBC driver could not be loaded due to system error code 126." What do I do? When clicking OK, the following warningbox appears: "Could not load the setup or translator library."
Trouble Connecting To MySQL On Windows Server 2003
Fatal error: Call to undefined function mysql_pconnect() <?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_connMySQL = "localhost"; $database_connMySQL = "database"; $username_connMySQL = "root"; $password_connMySQL = "mypassword"; $connMySQL = mysql_pconnect($hostname_connMySQL, $username_connMySQL, $password_connMySQL) or trigger_error(mysql_error(),E_USER_ERROR); ?> I installed the ODBC drivers as an optional solution, and that appears to be working when I test it within the program, but I don't know how to get my .php website to connect to it. .php files are working correctly on the server, but it's just not connecting to the database.
Lower Case MySQL Table Names On Windows Server 2003....
I currently administer our MySQL db version 3.23.56 on a Linux Cobalt Qube server via an external fron-end piece of software. My Table Names have capital letters at the beginning, i.e. StockMovements, OrderLines..... We are now implementing a cross-over to a Windows Server 2003 machine. I have installed MySQL version 4.0.20a and initially it was stated as 4.0.20a-debug. I managed to find another piece of software to take it out of debug mode as I thought this would help with the table names. The version is now 4.0.20a-max. If I rename the imported tables say from orderlines to OrderLines, it stays, but if I refresh or close/re-open my fron-end, all the table names have reverted back to lower case ? I have lots of .asp apps which are currently working of my Linux MySQL db using Capitals in the table names and fields. Obviously I do not wish to start re-coding all my web pages once I move accross to Windoes Server 2003 ...
Problem With MySQL On A Dell PowerEdge 1850 Running Windows 2K Server
I have 3 friends that installed MySQL 4.0.24 on their Windows 2000 Server platforms all on Dell PowerEdge 1850's. After one to two days - Windows gives an error that the EVENT LOG IS FULL and the applications lose connectivity to the DB. I have to restart the system in order to bring it back up. THis does not happen on Win 2003 nor 2000 Pro nor XP Pro. Only on Win 2k server on Dell PowerEdge 1850.
Installing MySQL On Windows Server 2003 (Intel Xeon Processors)
I am having troubles installing MySQL on my server, which has Windows Server 2003 as an OS. After downloading a package from dev.mysql, I tried to install it, but a message came up saying that this package doesn't support my Processors. Where can I get a package that does support my Xeon processors?
"table Is Read Only" After Copying Table Files To New Server
I'm trying to port my MySQL tables for a database called "tracerlock" from one server to another. On the old server, in the /var/lib/mysql/tracerlock directory, there was a ".MYD", ".MYI" and ".frm" file for every table in the database. So after creating a database called "tracerlock" on the new server, I copied these files over to the /var/lib/mysql/tracerlock directory on the new server. On both servers, all the table files are owned by user "mysql" in the "mysql" group. Now, when I connect to MySQL on the new machine and load the tracerlock database, "show tables" shows all the tables as expected, and I can perform SELECT statements on them and get the correct results. But when I try doing INSERT statements on one of the tables that was copied over, I get: mysql> INSERT INTO test VALUES(3); ERROR 1036: Table 'test' is read only However, if I create a new table called test2, I can perform INSERT statements on it with no error: mysql> insert into test2 values(3); Query OK, 1 row affected (0.00 sec) Code:
"table Is Read Only" After Copying Table Files To New Server
I'm trying to port my MySQL tables for a database called "tracerlock" from one server to another. On the old server, in the /var/lib/mysql/tracerlock directory, there was a ".MYD", ".MYI" and ".frm" file for every table in the database. So after creating a database called "tracerlock" on the new server, I copied these files over to the /var/lib/mysql/tracerlock directory on the new server. On both servers, all the table files are owned by user "mysql" in the "mysql" group. Now, when I connect to MySQL on the new machine and load the tracerlock database, "show tables" shows all the tables as expected, and I can perform SELECT statements on them and get the correct results. But when I try doing INSERT statements on one of the tables that was copied over, I get: mysql> INSERT INTO test VALUES(3); ERROR 1036: Table 'test' is read only However, if I create a new table called test2, I can perform INSERT statements on it with no error: Code:
STOPPING Server From Pid File
when i type 'sudo ./bin/mysqld_safe' i get: 'Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/homunculus.pid 060405 10:15:39 mysqld ended' would it be best to uninstall mysql completely and start over? if so, how do i do this in bash (yes, i've ordered the unix for beginners but it hasn't arrvied yet)?
STOPPING 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.
Importing .sql File In SQL 3.23 On Linux 7.1 Server
I've got a .sql file and was going to import it into mysql. The file contains around 30000 data but after i've typed: mysql> source /xx/file_name.sql; Table of the sql file is created but contains no data. But it poped an error notice without any message: ERROR: <----like this the .sql file is version 4.0. Is there any problems on version 3.23 while importing a v4.0 file? If so, could any brother please help on resolving this problem?
|
TRACKER
