Wrong Path In Component Services
I am running Win 2000. I need to change the MySql excutable path in
Component Services. When Iright click on Properties the path is wrong but
can't change it from there.
View Complete Forum Thread with Replies
Related Forum Messages:
Wrong Path To Mysqld Socket
Can you please advise which file to check to correct the following error:- Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/astbill/wwwroot/includes/database.mysql.inc on line 31 Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I have checked the my.cnf and it has the correct path /var/run/mysqld/mysqld.sock system is Debian Mysql server is ver 5 apache = 2.054
View Replies !
Data Transfer Services
Does anyone did DTS using MYSQL before? thinking to migrate from MSSQL to MYSQL.. If MYSQL can do DTS, then I don't need to do scripting to transfer data.
View Replies !
Mysql Services Windows 2003
------=_NextPart_000_0001_01C34BC2.26B3C4C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Why can't I start the service in windows 2003 server have any one a solution?
View Replies !
Windows SQL Services And Removing MySQL
I had installed mySQL when a programmer wanted to use it for a project. Then i uninstalled it. Now the MS SQL services (SQLserver, sql server activation directory helper, sql server browser, and sql server vss writer), cannot be started. The error messages seem to indicate that there are some files missing in order to run the services. I tried to re-install MySQL, but not it is giving me error zero when i run the configurator.
View Replies !
Remote Conn Via ODBC Or Web Services?
I need your help, I've developed an application succesfully using PHP and MySQL But in order to mantain the MySQL database I need to make constant connections from either Progress or Delphi It's been working just fine using the MySQL ODBC 3.51 connector, but only in the SAME machine (localhost) any other machine atmysqlting to connect remotely gets an error This implementation works if my customer has a dedicated server posted on the web, but other customers need to hire external hostings In that case, how can I connect progress or delphi to a REMOTE MySQL DB on a external SERVER?
View Replies !
Mysql Stock In Services Forgot To Remove
i have uninstalled mysql to put it on a different drive soon The old mysql stayd in Services and I dunno how to remove it from administrative services? Mysql is not installed atm i will install it soon in other words how do I remove from administartive services once i uninstall the whole thing.
View Replies !
Database Path
how can I retreive the path to a mysql database. I need to use it as a string in my program to find image files that are stored in the same directory?
View Replies !
Concatenating Path
I have been frustrated by this by some time now. I have a simple table like this:Code: id int(255) parent int(255) name varchar(255) path varchar(255) I am creating a hierchial table with `id` being the id of the record, `parent` the parent's id, `name` the name of the record, and `path` the path, from parent to child. My question is how to select the path from the parent, insert that into path, then append an incremental value. I am trying to do this in php in one query. So I am trying to form a query to do this.
View Replies !
Data Path
In the my.ini file (Windows version) can you set more than one data path i.e: datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/" datadir="C:/Some Other datapath"
View Replies !
How To Use A Path In A Query?
I'm having two db's tha are identical: dbase and dbase_test. Now I'm having some queries in files that I need to execute for both, and so I have used this: ----------------------------- use dbase; source c:/SQLscript/test.sql; use dbase_test; source c:/SQLscript/test.sql; ----------------------------- but the above will produce the following error: ERROR: Unknown Punctuation String @ 79 STR: :/ SQL: use dbase;# MySQL returned an empty result set (i.e. zero rows).
View Replies !
Path To Store Databases
If I have bought a faster harddisk, and want to point the path where databases previously stored to the new harddisk, what should I do? I am using FC5 and installed using rpm package.
View Replies !
Specify Data Path For Each Database
I just want to know if it's possible in MySQL to specify the data path of each database. I need to monitor the disk space usage of each database, and one way to monitor this is to partition my hard drive and assign each partition to a specific database.
View Replies !
Mysql/bin In PATH But Not Acting Like It
In my system variables, my PATH variable includes the value "C:Program FilesMySQLMySQL Server 5.0in." I have verified that this is the EXACT path to the directory containing all the MySQL executables. However, when I try to run one of them in the command prompt from another location, like C:, I get an error. C:> mysql 'mysql' is not recognized as an internal or external command, operable program or batch file. I have tried this with executables for other programs whose location is included in PATH, and they work with no problem. But for some reason none of the MySQL executables are being recognized. Any ideas?
View Replies !
MySQL Data Path
Is there any way in which I can change the data path of the tables required in my application. It defaults to the <MySQL Installation folder>/data. I want to be able to point to another folder. If I had to change the info in the STARTUP VARIABLES page and the Data Directory option it does not seem to make much difference.
View Replies !
Can't Change Datadir Path
I'm running MySQL 5.0.45-community-nt under Windows Vista Home Premium without any problems. In my LAN I have an ReadyNAS NV+ which I will like to use for for datadir. When I stop my MySQL instance, change the datadir path to the NAS and try to restart the service I get the following error in the log messages window: Trying to start the server ... Could not re-connect to the MySQL Server. Server could not be started. Can't create test file P:MySQL_dataASTERIX.lower-test Can't create test file P:MySQL_dataASTERIX.lower-test Aborting C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Shutdown complete Does anybody have an idea..
View Replies !
Bin Directoryh In PATH Variable
I've been using the command line tool as I do my first exercises in MySql, but I need to do some work with jdbc, and I'm wondering if I should add the bin directory into my PATH variable so I can run my sql from any command prompt window.
View Replies !
Select * From Paths Where Path Like 'a\%'
I switched a project from an unix to my windows system and recovered a lot of problem with the different path delimiter. i handle with pathes and want to get all (groups) all pathes which begin with certain folders. (So I get a group/tree structure like in a filesystem - nevermind) I made mysql_escape_... on 'a\%' but even if i took the statement and paste it in the console i find no solution. (Now i just cut the last backslash). 1. Is there no way from mysql-buildin-functions (or php) which treat this problem 2. How is the right sql? Ive tried: select * from paths where path like 'a\%' - seem to escape % => 'a\%' and select * from paths where path like 'a\%' - seem to also to escape % => 'a%'
View Replies !
Using Variable In OUTFILE Path
I am atmysqlting to create an XML text file for selected records using the following (simplified) code. The SQL statement produces the desired result as long as I leave off the INTO OUTFILE portion. And it works if I set the file name to a string i.e. ‘filename.xml’ and only send one record. However when I try to create multiple files by adding a variable filename, I get an error message: Unknown column 'AssemNum' in 'field list' CREATE PROCEDURE WriteFile(In StartID Int, EndID Int) BEGIN Declare Path text default 'C:/mysql/ '; WHILE StartID <= EndID DO Begin set @xsql = concat("select AssemNum, mySQLStatement from AssemData where AssemID = StartID; INTO OUTFILE '",concat(Path,AssemNum,'.xml'),"' LINES TERMINATED BY ' '"); PREPARE stmt from @xsql; EXECUTE stmt; SET StartID = StartID + 1; END; END WHILE; END
View Replies !
Space Character In Path
When displaying a filepath from a db if there is a space in the file name everything after the space is dropped. For example, if the path is c: est his doc.pdf it only shows C: est his Is there any way to include the spaces and everything after them
View Replies !
Minimum Path From 2 Point
I've a table with a list of spatial point. I need to find the minimum path from 2 point, through other point. For example, if I've this 3 point: (1 1), (2 1), (3 1) ..and I set as beginning point (1 1) and as finish point (3 1), I need a procedure that return all the middle points, in this case (2 1). Anyone has any idea??
View Replies !
Problems With MySQL X-Path
I have an X-Path problem here. I have the following XML structure: <OAI-PMH xsi:schemaLocation="blabla"> <ListRecords> <record> <metadata> <oai_dc:dc xsi:schemaLocation="blabla"> <dc:title>Just take her seriously</dc:title> <dc:creator>Weijmar Schultz, W.C.M.</dc:creator> </oai_dc:dc> </metadata> </record> <record> <metadata> <oai_dc:dc xsi:schemaLocation="blabla"> <dc:title>John's Book</dc:title> <dc:creator>John</dc:creator> </oai_dc:dc> </metadata> </record> </ListRecords> </OAI-PMH> Having the name of the creator, I'd like to extract the title of the corresponding record. E.g. I want to know the title of the record, whose creator is John. I'm running MySQL 5.1. The xml structure is stored in a column "xml_content" in a table "xml" and I use the following X-Path expression: ExtractValue(xml_content, '/OAI-PMH/ListRecords/record/metadata/oai_dc:dc//*[dc:creator="John"]/dc:title/) from xml; Unfortunately, it doesn't work. Would you tell me whether my X-Path expression is wrong or my mistake is in the use of ExtractValue().
View Replies !
Path To Executable Incorrect
I have recently taken another stab at installing PHP/Apache/MySQL on my box so I don't have to shell out 40 bucks a year for hosting. I attempted before, and I failed miserably; I'm taking another shot at it because I have a new book which seems pretty succinct. I have reinstalled MySQL, but when I attempt to start the service, I get an error that says the path to the executable is wrong. I checked, and it's “C:/FoxServ/mysql/bin/mysqld-nt.exe”, which doesn't even exist, instead of “C:/mysql/bin/mysqld-nt.exe”, which is the correct location. So, I need to change that path... but how?
View Replies !
Community To Enterprise Upgrade Path
We are a start-up business which has decided to use MySQL Community version but as we grow we dread the thought of redoing everything when we are ready for the Enterprise version. Is/will there be a utility/program that will simplify this process?
View Replies !
Adding File Path To Database
I'm trying to add file path's to the database but when I atmysqlt to add the string C:UsersuserDesktopDatabase-Test-2filename.rar to the database i get C:UsersuserDesktopDatabse-Test-2filename.rar
View Replies !
Change Path To MySQL Databases
I have a server where the databases are currently stored in /var/lib/mysql They are out growing that partition on the hard drive and I need to move them to another partition... Let say /home/mysql How to I tell the mysql core program that the databases are to now be stored there and not in the old location?
View Replies !
Path To Executable Disappears Xp Pro Service
I have installed MySQL 4.1 as a service on Windows XP Professional several times. Each time I used the Windows Essentials (x86) installer version 4.1.20, (mysql-essential-4.1.20-win32.msi). I always accept all the default options. After the install everything is fine for a while. Before I reboot, after one or more reboots, MySQL works as expected. Then at some point the "Path to executable" value disappears from the service properties window and I receive "Error 3: The system cannot find the path specified" when I try to start MySQL. If I open a command prompt, change to the bin directory and execute mysqld-nt.exe nothing happens. I do not see anything in any of the event logs related to MySQL. This has happened at least three times inbetween which I did not alter any Windows configuration settings. If anyone has encountered this before or has any suggestions as to what might be causing it or what I can do to prevent this.
View Replies !
Varchar To Image Link Path
i am creating an SQL table and one of the fields is going to be a image link path. This will be a varchar. But I am unsure what size I should make that. Any ideas.
View Replies !
Path Of MySQL Database In Microsoft LAN
All computers in the LAN are running windows OS. The MySQL database is installed on a server and a script is running on a client. I have problem to use the script to connect and query with the MySQL database. What is the path or address of the MySQL database?
View Replies !
Upgrade WIN32: From 5.0.x To 5.1.x -- Easiest Path?
i tried to upgrade a 5.0.x to 5.1.x on win xp pro box. i read mysql's online docs. but apparently, the data directory didnt copy over nor did the important users info... what is the easiest way to do this? here what i did: 1. stop mysql5.0 service 2. run the 5.1 install wizard. 3. but it fails. so i manually start 5.1 service. reboot machine. but non of the data is moved over. is there a simple to do this without me reinventing the wheel?
View Replies !
Load Data Infile :: Can't Get Stat Of '{file Path}'
I am having a problem loading a csv file into a MySQL server running on a remote machine. I am getting the error: Query failed with error(13) : Can't get stat of '{file path}' (Errcode: 13). The path is the absolute location on the uploaded file. I have, for the purposes of ruling this out as a problem, given the both the file and directory full permissions to everyone. The file is definately in the location given by {file_path} as I have checked. I have file permissions. As the MySQL is administered by an external hosting company, they have disabled the 'Local' sql statement. Does anyone have any ideas as to why I am getting this error?
View Replies !
LOAD DATA LOCAL INFILE :: Path In Novell
I'm trying the 'managerie' tutorial. At the mysql prompt (NW server console) I'm typing: mysql> LOAD DATA LOCAL INFILE 'pet.txt' INTO TABLE pet; the response is: File 'pet.txt' not found (Errcode: 1) What is the correct syntax for PATH while in Novell? The file is on server=WEB, volume=MySQL, datamanageriepet.txt.
View Replies !
Pre Order Tree Structure Reverse Path Lookup
Can this be done in one query? We only have the titles of the categories to search by. $titleX_left simply stands for the left_ value obtained from the previous query, same for the right_ value. SELECT * FROM category WHERE title='Title1' SELECT * FROM category WHERE title='Title2' AND left BETWEEN $title1_left AND $title1_right; SELECT * FROM category WHERE title='Title3' AND left BETWEEN $title2_left AND $title2_right; Keep in mind titles could be duplicated in sub trees. So we could have: ->Cars -->2door ->Trucks -->2door Thats why simply looking for ƈdoor' will not work (or in the query example above, 'Title3'). We must start at the highest level node and work our way down the tree because there could be "same names". There is an unlimited potential of levels here so if there is a way to do this with 1 query let me know.
View Replies !
Wrong Definition
Is this a wrong definition of a mysql db? (no defaults defined) : `date1` int(10) default NULL, `date2` int(10) default NULL, `num_jokes` int(8) unsigned NOT NULL, `title` varchar(255) NOT NULL, `path` text NOT NULL, etc... etc...
View Replies !
Wrong Results
I have the following select statement Code $query_Recordset1 = "SELECT * FROM data where('$beds like $options')"; the $beds variable is a text field, and the $options variable is a drop-down menu. Technically the query works, but when i put in 775 and click ZIP in the drop-down box it shows zip codes that dont even start with a 7, much less a 775
View Replies !
Sorting Is Wrong
I have some products in the database and trying to sort them ascend. by their prices. But for example, the price $14.00 comes before than $8.00. How can I correct the problem? As I understood, mysql only checks for the first digit. Not the whole.
View Replies !
Wrong With My Syntax
if I have the following tables in my database: +-----------------+ | Tables_in_test | +-----------------+ | temp | | tempallclaims | +-----------------+ 2 rows in set (0.00 sec) shouldn't the following statement: "select * into temp from tempallclaims;" be a valid SQL query? I keep getting an error message. i've also tried a non-existent table name: "select * into tempBack from tempallclaims;" but its a no-go as well.
View Replies !
Used Wrong Password
I installed MySQL through XAMPP application to Windows XP SP2. All was well, I opened the ADMIN of MySQL from the XAMPP Control Panel and received a drop down box asking for user name and password. For username I used my own name. I have since found out that I should have used "root".I went through a whole bunch of problems with "access violation messages which are still coming, although now I know how to shut them off, but I cannot access MySQL at all to change the password to what it was supposed to be.In essence, I cannot use it at all, and I don't know how to make the fix. Could someone please advise?
View Replies !
Something Is Seriously Wrong In 5.1.x Releases
I am runnging 5.0.67 with no problems, but every time I upgrade to some of the 5.1. releases in 24 hours my mysql freezes and I get too many connections. After trying to quit it never stops, I have to reboot. I can not see what is wrong. And ideas? I am running Windows 2003 with myODBC 5.1 and mySQL 5.1.28 (until it freezes, than I am back to 5.0.67) :-(
View Replies !
What Is Wrong With This Syntax
I must be staring at this query to hard. This query is called within a block of PHP code. "UPDATE business SET businessName='$business', profile='$profile', catId='$cat', WHERE id='$id'"; I get an error that says the following: "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 'WHERE id=ƈ'' at line 5" The query looks good to me. The id is supposed to = 2.
View Replies !
What's Wrong With This Insert?
INSERT INTO zips (zip, lat, long, city, state, county, type) VALUES (?','+40.922326','-072.637078','HOLTSVILLE','NY','SUFFOLK','UNIQUE');
View Replies !
Can Anyone Tell Me What's Wrong With This Query Please
PHP $kkdx = @mysql_query("select id, ".$kli." from secteur order by position") or die(mysql_error()); while ($kkdx1=mysql_fetch_array($kkdx)) { print '<h5>'.$kkdx1[1].'</h5>' $kat_details=@mysql_query(" select members.lastname, members.firstname, members.title, // title = member's field members.localization // localization = member's field from members, localization, // localization = seperate table title // title = seperate table where members.Secteur = ".$kkdx1[0]." and members.localization = localization.id order by localization.position, title.position "); while ($abc=mysql_fetch_array($kat_details)) { print $abc['lastname'].' '.$abc['firstname']; } } I am getting much more rows than what I should get, not ordered as I want, etc ... totally messed up
View Replies !
What's Wrong With SELECT *?
This has been bothering me for a while now, so I decided to come here for some answers. I was told very early on not to use SELECT * and to always specify each field that the SELECT statement should target. This makes sense to me since MySQL doesn't need to do the extra work of going to see what fields are available then finding the data... so its faster. But what if I know ill be selecting every field in the table. And what if that table has 10+ fields. It becomes a pain having to type out all those fields just for a ( minor?) boost in query speed. This becomes even more of a problem when I have multiple queries either on their own or in stored procedures that are all pulling out the same data. If this is the case and I need to add/rename/remove a field from the table then I have to hunt down every SELECT that is targeting that table. Basically im looking for good reasons why I should/shouldn't use SELECT *.
View Replies !
Mysqlbinlog Wrong Output
I get following output from "mysqlbinlog mylog-bin-file.001": # at 4 #030818 13:38:00 server id 1 Start: binlog v 4, server v created 700101 1:00:00 The file mylog-bin-file.001 contains many queries but they don't appear in the output from mysqlbinlog. What is wrong?
View Replies !
Wrong Syntax Constraint
1)I'm trying to create a new table but the creation fails because I insert as a wrong syntax of the keyword 'constraint'. For example... TABLE xxxx field 1 cod field 2 name field 3 is_died (boolean) field 4 died_date (date) I would like to chek if is_died == true then died_date must not has NULL value and viceversa if is_died == false then died_date must has NULL value. 2) I would like manage constraint between two table but I have no idea about it.
View Replies !
Whats Wrong With Using A BLOB?
the previous programmer for the html/php site i now have the reins of used a mysql database, but for SOME reason he decided to post product images to a file directory--rather than store it in a BLOB. i haven't had ANY experience with BLOBs so i'm wondering if he knew something that i didn't. the only problem i could possibly foresee is that we watermark our images. but the original photo is NOT watermarked--it is done in realtime by another page that hands the photos out on request. so, is there any reason i shouldn't be using BLOBs to store images? currently, a problem that has come up quite frequently is when we rename an item code, that the function he created to rename the image is not working. now, i have no idea why he didn't assign image names based on the autonumber id (which would never change) so i'm just wondering if he really didn't put too much thought into this area. what do you guys think?
View Replies !
|
TRACKER
