Accessing Mysql/bin Directory Problem
This may be very basic question, that I hope some of you can answer very quickly for me. I'm running mysql 4.1 on windows xp just to learn the database, and I'm in a need to run .exe in the bin directory. The problem I'm having is accessing this directory. The path is C:/Program Files/Mysql/Mysql server 4.1/bin but when I get to C:/cd "Program Files/..." I get an error message saying (parameter format not correct - "program) i have tried several things, as well as following a user guide for changing directories that states that if the folder name has spaces use " to access that subfolder...maybe there is a simple tip ...
View Complete Forum Thread with Replies
Related Forum Messages:
MySQL Root Directory
I am using flex for interface, java for intermediate code and mysql for DB. My website contains videos so instead of uploading them on db, i have instead put a path in db and stored videos on machine. the path is '/images' for images and '/video' for videos. Before I was using IIS server and when i used to put my index.html (along with .swf and .js) file and 'images' and 'video' folder in /inetpub/wwwroot folder, it used to work fine. now i am working with tomcat, and i have tried placing 'images' and 'video' folder everywhere but its not working. I am sure that database is connected because there is some info of videos stored directly in database that i get.
View Replies !
MySQL Or Directory Tree?
I'm working on a project where I have about 5 different data structures (objects) consisting of about 15-30 fields each. The size of each object is about 2-4 kB. The maximum number of objects will be in the range 5000-100000 for each object. I need possibility to search, add, delete, update and get these objects by ID, NAME, DATE and VERSION only. I have no need for the individual fields of the objects only complete objects as binary files. When I work with the objects I need access to roughly 5-10% of the objects at a time. Right now I have all these files in a directory tree under Windows XP with ID, NAME, DATE and VERSION included in the file name. I can do all I need but it becomes too slow sometimes. Now to my question: Can I benefit something from moving to a MySQL database when it comes to performance and speed and how should I set up the datbase to make it as fast as possible?
View Replies !
Accessing Dev.mysql.com
I'm trying to download MySQL4.1 from the MySQL site and when I try and go to the download section on the site it either fails or, if it loads, the "pick a mirror site" links always fail. By "fail" I mean that it doesn't manage to retrieve the requested page, either sticking on "waiting for dev.mysql.com" or "connecting to dev.mysql.com" in the status line of the browser, eventually giving up with an "operation timed out" error message. Is anyone else having this problem or is it just me? - this has been ongoing for the past couple of days now. Incidentally, I need a version of MySQL that can handle subqueries yet I'm still using glibc-2.2.5-40 and Redhat 7.3 (upgrading simply isn't an option right now) - can anyone suggest a stable sub-version of 4.1 that fits this criteria?
View Replies !
Import A Directory Of Text Files Into A Mysql Database With Php?
I have a directory of text files that i'd like to import into a msql table... I was wondering if there's an easier way to do this with php/mysql, I'd like to avoid copy/pasting the entire directory (thousands of files) into the database if i can. The directory structure of the text files resembles... somepath/A/Aerosmith/Song Name.txt - (extention varies) What i'd like to do is use php to scan the directory and input the file path information and the content from each file into a table like... Dir Artist Song Text Type ------------------------------------------------------------------------ A Aerosmith Song Name Fa La La La La (example text) File Ext B Beatles Song Name Fa La La La La (example text) File Ext
View Replies !
Accessing MySQL DB From Another Domain
what is the best way to access data in a MySQL database on one domain from a PHP script on another. We have a secure (SSL) server on one domain which will be used for secure credit card transactions. We would like to be able to extract insecure contact information from MySQL database on another domain in another hosting environment.
View Replies !
Accessing MySql On Yahoo
I have never used MySql before.I program in C# and Visual FoxPro against MS SQL on a corporate network. I have a Yahoo web page, and I'm going to use their MySQL DB. I want to run queries, Inserts, Updates and Deletes. I have no idea how to connect to MySql on Yahoo from a client like C# or VFP.
View Replies !
Accessing MySQL Database.
I have recently installed MySQL 5.0.27 / PHP 5.2.0 / Apache 2.2.3 on an XP os. I created an empty database via the MySQL command line which is visible when I type SHOW DATABASES at the mysql prompt. I have changed my root password which works OK. I set up the password to the empty db by: GRANT ALL ON database name.* TO username@localhost IDENTIFIED BY 'password' To access the db, when I type : mysql -D dbname -u username -p I do not get a prompt to enter the password.
View Replies !
Accessing Mysql From Another Host
New install of mysql on Solaris 10 x86. I cannot connect from any other host, lots of traffic on google with people with the same error. Talk of the grant command fixing this, but no details. So simple question. What "exactly" do I type to allow connections to port 3306 from another host to avoid messages such as ERROR 1130 (00000): Host 'am-ms-t.foo.baa' is not allowed to connect to this MySQL server
View Replies !
Accessing MySQL Data
This morning when I tried to access my MySQL installation through MySQL Query Browser, all schemas have a message stating "Fecthing Data..." when I expand the schema. If I access MySQL through the command line, I get the following message when I execute a "use" command: "Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A" If I execute mysql using "-A", then it appears I can access the data, but it's very slow. Has anyone experienced this and if so, do you know how to resolve it?
View Replies !
Accessing Mysql Server On LAN
I have a problem accessing mysql server on my LAN: i can access it locally but not from other machine. The error is: Lost connection to mysql server during query. I've disabled the firewall but it's still not working. What i don't know is if i set the users correctly...
View Replies !
Accessing A Mysql DB Remotely
I am building a kiosk which uses a lockdown browser. The browser uses a php page to access a MySQL DB on a web server. It will not allow me to connect to the DB because I am using the following connection string: mysql_connect("localhost","*****","*****"); mysql_select_db("******") or die ('I cannot connect to the database because: ' . mysql_error()); I know that the problem here is that I'm trying to connect to 'localhost' when the actual DB resides elsewhere. The question I'm asking is how to find out how to connect to my DB. Is it just mysql.mydomain.com instead of localhost or what?
View Replies !
Which Is The Right Directory To Backup MySQL Database On Linux Opearing System?
Implemented web application using MySQL to maintain inventory of the office PC's/laptops/Routers/hubs and other stuff, here we are using MySQL as back-end Database on Linux Operating system. I need to backp all these Inventory database into CD/Tape/Floppy, which is the right directory (MySQL database) to backup (incase if the current MySQL server crashes, then I should be able keep copy of my inventory),
View Replies !
Error 1130 When Accessing MySQL From Another IP??
I am trying to run the MySQL DB on a Linux machine that is part of a home LAN (IP=192.168.0.3), while trying to access it from another WinXP machine (IP=192.168.0.5). I keep getting the following error: MySQL Error Number 1130 #HY000Host '192.168.0.5' is not allowed to this MySQL server Ping works fine. On searching the internet, I find reference to "allow list" hidden somewhere in the guts of MySQL. Can anyone provide me hints on how to add to this list?
View Replies !
Accessing Mysql After Fresh Installation
I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After installing when enter into mysql it gives me message " Access denied for user root@local host .......using password yes" i have tried all the options like #mysql -u root -h localhost #mysql -u root -h localhost -p #mysql -u root -h localhost -p mysql #mysql -u root -h localhost test -p #mysql -u root -h localhost test #mysql -u root #mysql -u root mysql but none of the option is working at all. Please any idea how i can change the root password or enter the mysql after fresh installation.
View Replies !
Accessing Mysql Database From Php File
I can access mysql in dos with the command of c:mysqlinmysql -u root mysql but when i write the command of mysql_connect ("localhost", "username", "password") i don't know what my username or password is. I have installed Apache to run the mysql database and php on my computer although I don't know where to find out the username and password so if someone could help that would be great.
View Replies !
Accessing Mysql From Command Prompt
The path to my mysql installation is "C:Program Filesxamppmysqlin". I want to run myisamchk - to do this I think I have to access it via the command prompt. A stupid question - I kmow - but how do I get to the directory in a DOS window??
View Replies !
Accessing Remote MySQL Database
Is it possible to access remote MySQL databases? I manage several sites and I will soon be building a tool that can track all of them, and it would be really convenient if I could somehow access all of the databases from one remote site.
View Replies !
Accessing MySQL BLOB Columns Using Visual C#
I am trying to write an image file to a remote MySQL Database. The following code show the section I try to save the ImageArragy into the MySQL BLOB column. The error that I am getting is : Can someone tell me where I am going wrong and how I can fix this problem?
View Replies !
Accessing Data On An SQL-Server By Using MySQL-Select
is it possible to access data located in a SQL-Server-Database by using a MySQL SELECT-Statement? I know that on an I can use a qurey like the following SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:Financeaccount.xls";User ID=Admin;Password=;Extended properties=Excel 5.0') on an MS-SQL-Server and search for something similar in MySQL.
View Replies !
Accessing A Mysql Database On A Remote Server
i would like to know how to connect to a remote mysql server which is on linux from a windows system. I gave the command: mysql -u root -p redhat -h 192.168.1.132, where the ip is the ip of the linux server. But i got the error message stating that :- Host 192.168.1.114(which is my system ip) is not allowed to connect to this MySQL server.Sreejith
View Replies !
Accessing MySql Thru Coldfusion - Password Problem
I have downloaded MySql 5.0 for Windows (XP) and MySqlCC so I can interact with it. When I installed MySQl I created a username and password which I can see in "my ini" file. I don't remember creating any passwords through mysqlcc. I am building a database driven website using "macromedia studio MX" and am experiencing problems accessing my Mysql database through that software - I keep getting asked for a login ID and password, and for the life of me, have no idea what they are. 1. When I originally added my database as a 'data source' in Cold Fusion (MX 6.1 administrator) it would not let me create a password. I kept getting error messages like "The root cause was that: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'martin'@'localhost' (Using password: YES)" etc etc etc variations on that theme. (adding the database without a password wasn't a problem) 2. Now I am trying to create a dynamic page in Dreamweaver (using Coldfusion) to display my data – there is a 6 point process in the ‘server behaviors’ tab and I’m up to the last one “press the (+) plus button and choose ‘Recordset (Query). WHEN I SELECT MY DATABASE AS A DATA SOURCE IT ASKS ME FOR A "LOGIN ID" AND "PASSWORD." I've tried all the passwords I can think of that I used and nothing works, the error message I get is: "-1:Syntax error or access violation: 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 'wine like '%' at line 1. this is then followed by about 27 lines of commands like "at org.gjt.mm.mysql..".bladedblahdeblah " (I am creating a database of wine tasting notes)
View Replies !
Accessing Mysql On Win2003 Server From A Station
I have installed Mysql on a Win2003 server and it is running as a service. I created a database and it works ok on the server logged on as root. I then tried to access the database from a station on the network using PHP code and I get the error - Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in G:InetpubWWWrootIntranetookingacc.php on line 10. Do I need Mysql Client on the station or does it run on the Server by default?
View Replies !
Error Accessing MS Access Table Linked To MySQL
I create the linked tables without any problems, clicking on "save password" before selecting the desired tables. I can then access both tables fine from within the Access GUI. The problem starts when I then try to access this data from my ASP.NET web application - classic ASP works fine but .NET gives me... ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'MyDSN' failed. From then on, the Access database remains locked (.LDB file in the same directory) and I get a similar error when I run my ASP page, which previously worked. Code:
View Replies !
NAS Vs SAN For Data Directory
I am trying to decide which storage I should use for the "Data Directory". My application has lots of 'SELECT's (80%) and fewer UPDATEs/INSERTs(20 %). I have the following choices of Data storage 1) Xiotech SAN (66 Mhz FCAL) 2) NAS 3) Internal SCSI 3 RAID 5 Will I achieve any better performance using one storage vs the other storage? In the past (for about 2 years), I have I used SAN with 33Mhz FCAL, and the performance has been quite exceptional. And I have encountered no problems.
View Replies !
Filerights To Certain Directory
How can I give(grant?) the mysql database rights to write in directory /opt/guide/www.domain.com/HTML/upload/test How should I set my rights. A local user 'userA' should have the rights. How should I set these privaliges without opening the gate for everybody?
View Replies !
Directory Name Invalid
For testing purposes I have PHP installed and I have MySQL installed on my local laptop. Windows XP Pro I am just learning both of them. I have read quite a few chapters in the MySQL Manual. Enough to allow me to get around in MySQL and directly create tables an view information in them, upload .txt files into the tables, etc etc. I am receiving an error when I try to connect to MySQL via a PHP script. I have no problem connecting to MySQL via Command Line. The error I receive is "The directory name is invalid." Here is my code... I am not sure where to put the directory name or where to put the directory path in order to make it valid. I am not sure what directory it is talking about. <html> <head><title>Connect to MySQL</title></head> <body> <?php //connecting to the mysql server uses a mysql_connect command. $link = mysql_connect("locoalhost",$_POST['username'],$_POST['password']) or die("Connect Error: ", . mysql_error()); echo 'Successfully Connected. '; mysql_close($link); ?> </body> </html> Where exactly would I put the path to the directory or where would I name the directory?
View Replies !
DB For Directory Service
I am creating a new database for a directory service. I have thousands of records, and every record has one suburb (out of 35). %90 of the records has also one district name (district is a small suburb, every suburb has around 3-10 district) Some of the records have two districts. (one record can have maximum one suburb and two districts.) Suburbs and districts are constant, so I won't be adding any new records for them in the future. When visitors search something from the directory, they will enter either one suburb name or district name. What I have thought is that I would create a table which has suburb, district1 and district2 columns. If someone search something, I will compare the location in the script, if it is a suburb, then I will only search it from the suburb column, if it is not a suburb then I will search the district1 and district2 columns.
View Replies !
Database Directory
I have some trouble understanding the workings of the DD tables, and found very little information online. I understand WHAT the DD is, but not it's precise structure. I was wondering whether anybody knows of any resources that may help me understand the system DD table's structure, and they work (e.g. which tables are used when evaluating expressions, which tables are checked for user permissions etc).
View Replies !
Membership Directory
I know this is probably a dumb question for all the experts out there. But I have to ask because I'm trying diligently to work at home and want to be successful. How difficult is it for someone with an Access background and pretty fair understanding of differing programming lagnuages to build a member directory that currently house 16,000+ members. The client wants it done by 8/1. I have yet to sink my teeth into a real web database, shall I take the chance? I'm a quick study and have taught myself most of what I know. I've basically gone to school to learn little things I've missed to Ace a class on something I already know, but is mandatory for my degree.
View Replies !
What Directory For Basedir ?
What should i set my basedir to ? I thought /var/lib/mysql would work. I am trying to run /mysql_upgrade script but it keeps on bitching about the basedir - can't find the mysql command line client. Which file does this refer to ? Code:
View Replies !
Using INSERT To Write To A Directory
I have a problem that I'm not sure if it can be done. I'm trying to use the MySQL C API to be able to use a normal sql insert statement that will send the data or file to a directory and NOT the database. I'm not sure if there is anything out there that will allow this, but I've searched everywhere, and I have found no solution.
View Replies !
Arrays And Altering Directory
I am new to this forum. I intend to share my knowledge of MySQL wid everyone here and also gain more than wat i can share. My queries are: 1.Does MySQL provide arrays. 2.Can i change the directory which stores the databases that are created by the user. Besides Pls check www.mysql.com homepage abt a security alert regardin MySQL on Windows. there is sum worm call UDF........anyways i hope to obtain a reply soon.
View Replies !
Errcode 17 In Temporary Directory
I run a web server (on IIS) with a big site on it. It has php5, mysql 5 and odbc 3.51 It has 640MB of ram. at random times I get this error (not always the same file, but similar): [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-log]Can't create/write to file 'C:EasyPHP mp#sql_3fc0_0.MYD' (Errcode: 17) If I go to that directory and delete that file, the problem disappears. But until I do this the pages display a mysql/odbc error and nothin works. So if it happens at night or when I'm out, my website will remain down for a lot. Really annoying problem!! I googled the errcode 17 and found out that it can be caused by: - directory permission problem > this is not my case, I've given correct permissions - an antivirus performing a scan in the temp directory > this is not my case So what is this?! Code:
View Replies !
Hidden Directory FOUND.000
using MYSQL on my linux device , MYSQL has been installed on the CF Card. THe problem that i am facing is that whenever some data gets written on to the database there is a Hidden forder called as FOUND.000 which gets created and starts occupying the memory space. I found the folder when i used the CF Card with Card reader and saw the contents of it through windows. But my application is running in Linux and hence i dont know how to delete the folder at runtime since it is hidden. Can anyone suggest a way to do it. Or is there any command which will disable the creation of the folder.
View Replies !
Create A Directory-search
I'd like to create a form to search in my database that is a directory. It contains an important list of persons with their names, firstnames, telephone numbers etc. Do you know where I could find a script to help me? I'd like to create a multi-criterions form.
View Replies !
Creating A Community Directory
The goal is to create entries for a Community Directory: Smith John Sally 8786 Regional Way Somewhere, OR 97224 Child1 Child2 Child3 Using the following code I've been able to get close, but the records are repeated for each entry in the fam table: select concat(hld.l,' ', hld.f,' ', hld.sp,' ', hld.ad,' ',hld.city,' ', hld.st,' ', hld.zip,' ',hld.ph,' ', fam.ff,' ', fam.rel,' ') from hld, fam where k = fk order by hld.l, fam.rel Smith John Sally 8786 Regional Way Somewhere, OR 97224 Child1 Smith John Sally 8786 Regional Way Somewhere, OR 97224 Child2 Smith John Sally 8786 Regional Way Somewhere, OR 97224 Child3 Obviously, I need a way to collect these multiple records into one record like the initial sample above.
View Replies !
Working In A Windows Directory...over The Web
Is there a way to set up a database so it reads a windows directory? Like the W:/ drive? Or have a function that moves files from W:/ to C:/? and then have this functionality over the web? Where do I start? I want this to be simple but all the resources I find are complex or more toward website stuff. I’d like to develop the frontend with PHP and have it interact with VB as well.
View Replies !
|
TRACKER
