Windows App To MySql Table
I have a C++ Builder APP that uses the Advantage database. I want to export
data from the Advantage tables to a MySQL database on my website.
What is the best way to get my data into the MySQL table ? I am only
looking at 10-15 records, but I would be updating every 10 seconds or so.
I could create a text file and upload it via FTP, and then a PHP script
could load the text file into MySQL, but I am sure you guys know a better
way to do it.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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 ...
Table Names On Windows/Unix
My development machine is Windows, while the production machine is Unix. I'll create a table on the Windows machine called "ABCD". I'll name it the same on the Unix machine. However, for some reason, the Windows mysql will rename it to "abcd", I assume because Windows is case insensitive. Of course, when I deploy the app to Unix, it crashes until I go through all my code and rename all database references and xml to "ABCD". Is there a way, on Windows, to make sure it calls the table "ABCD", so when I use my IDE's, it brings the tables in with the proper name?
Custom InnoDB Table Space In Windows
In Windows, there are lots of config files for MySQL. When installing MySQL, the config wizard created a single, autoextending ibdata1 file for InnoDB tablespace. However, I want to customize the tablespace. Instead of innodb_data_file_path = ibdata1:10M:autoextend I would like to have something like this innodb_data_file_path = ibdata1:650M;ibdata2:650M;ibdata3:650M But when I make this change in the file my-innodb-heavy-4G.ini the server fails to start. How can I change the default config for InnoDB and customize it to my needs?
Table "hard Links" Under Windows
I am attempting to create "Symbolic" or as windows calls it "hard links" for some tables in a database. I have 2 databases, db1 has a users table that I created a 'hard link' to in db2. I created this using this program which ads shell intiration for hard linking: http://www.elsdoerfer.info/=ntfslink The hard-link appears to work, I tested with a simple .txt file and i can make changes to one file and open the other and see them. The 2 databases were working fine for awile after I created these hard-links, then things started to go wrong. It seems whenever I try to add a new row to the users table in db2 (with the hard-link) the change doens't show up in the same table in db1. It also corrupts the table. And same the other way, I added a bunch of users into the table in db1, then did a CHECK on the users table in db2 and it gives me this "Size of datafile is: 6872396 Should be: 6874300". So it seems part of the data is being written, since it knows what it should be. I read that one can do this type of setup in linux with symbolic links, maybe it doens't work with windows hard-links? It seems it should... maybe i'm missing something?
MySQL On Windows
I downloaded and installed MySQL for Windows this morning, V4.1. = Unzipped, installed and started the server as a service, no problems. = Installed the ODBC driver. A-OK But, the DOC tells me I have to run "mysql_install_db.sh". So, the = question is, how am I supposed to run shell scripts on Windows?
Mysql 4.0.20a For Windows
i installed just a few days ago the new my sql 4.0.20a server on a Windows Machine and heart about that the feature "auto_increment = default value" will work now now i created a new table added some fields and one field shoud be auto_increment and shoud have a default value (which means, mysql shoud then auto_increment up from the given value), but this doesn't work i can only choose between default value or auto_increment but not both any ideas ?
MySQL 4 And Windows XP
I am having problems running mysql 4 on windows xp. Mysql 3 works fine. However version 4 won't run. Even if I start the server with the admin panel it shuts down again after a couple of seconds. This has only been a problem since I wiped my hard drive and did a clean install of everything.
MySQL 5.0 On Windows 98 SE
I just downloaded MySQL 5.0 and installed it on a machine that I just did a fresh install of Windows 98 Second Edition on. The install seemed to go smoothly, and when it was done I try to start mysqld from the command line and get this: C:Program FilesMySQLMySQL Server 5.0in>mysqld --console 051125 21:04:07 [ERROR] Can't find messagefile 'C:Program FilesMySQLMySQL Ser ver 5.0shareenglisherrmsg.sys' 051125 21:04:07 [ERROR] Aborting Also, when I look in the above referenced directory, the file errmsg.sys is there: Code:
Mysql On IIS Windows
I very new to mysql. I would like to get some advise on which release i should install in my windows 2000 server using IIS.
MYSQL In Windows XP Pro Sp2
i get a ERROR 0 when loading the program into my computer. and the servise could not be started, if i go into cmd and type "Net start MYSQL" it says sucsessfull but when i go into Contrl panel > Administrtor tools > Servise's and click MYSQL it says "error 1067 could be be started"
Can I Use MySQL With A Mac And Windows
I need to share a MySQL database with a guy that uses a Mac, but I don't know anything about the Mac environment. I use WinXP. He has a server that has MySQL loaded on it. I want to create the database, then both of us want to be able to access it or make changes to it via the web. What type of products do I need? I figure a good MySQL reference book is a necessity. Is there some type of front end application that he can run. I think I can run Access as a front end once it is set up properly. Am I making sense?
MySQL 4 And Windows XP
I am having problems running mysql 4 on windows xp. Mysql 3 works fine. However version 4 won't run. Even if I start the server with the admin panel it shuts down again after a couple of seconds. This has only been a problem since I wiped my hard drive and did a clean install of everything.
MySQL On Windows
I downloaded and installed MySQL for Windows this morning, V4.1. = Unzipped, installed and started the server as a service, no problems. = Installed the ODBC driver. A-OK But, the DOC tells me I have to run "mysql_install_db.sh". So, the = question is, how am I supposed to run shell scripts on Windows?.tw
MySQL On Windows
when i try to install mysql on my pc it works just fine until i'm near the end of the installation, the installer writes: the security settings could not be applied error number 2003 can't connect to mysql server on 'localhost' (10061) i have disable my firewall... so whats the problem then..? please make an easy explanation... i'm not that good at english so i hope that you understand me...
Mysql On A Windows Box
there are two options for mysql when it comes to windows...there is a 'windows essentials' and then there is the normal download. the documentation says the essentials package, (it's almost half the size) is the recommended one because it has all that is needed. i don't really care if i download the biggest file size, but if i don't need to, i'll take the smaller package.
Upgrading MySQL On Windows/IIS- Help?
I am running MysQL Version 3.23.49 on a Windows IIS machine. I need to upgrade it to at least 4.0.16 (to install vBulletin 3.6). Is there a good tutorial on how to do this? I look at the documentation on the MySQL site but I'm hoping there is more out there to help me. As well, the docs say instead of upgrading to V5 I should upgrade to V4 instead. I'd like to have the most up to date MySQL if I can so I won't have to do the another upgrade for a while.
MySQL / Windows XP SP2 Incompatibility
I've been posting the problem earlier on Microsoft newsgroups (cannot use support, because of using OEM Windows): Windows XP SP2 Security Center stops recognizing antivirus and firewall software when I install MySQL server and GUI tools (MySQL Administrator and MySQL Query Browser). The only way to make the Security Center recognize the software again is to restart it using Services snap-in. Is it a bug on Microsoft side or on MySQL team side? Are there any solutions for the problem? Configuration: Intel Celeron 1200 MHz / 512 MB RAM Windows XP Home Edition with Service Pack 2 MySQL 4.1 with the latest versions of GUI tools
Cannot Get MYSQL To Start In Windows
Here are some of the errors I receive when trying to start mysql under windows xp home edition: When I goto mysql command line client the client start but If I hit a button it shuts down. When I type this: C:>"C:Program FilesMySQLMySQL Server 5.0inmysql" test ERROR 2013 (HY000): Lost connection to MySQL server during query Or I try this: C:>"C:Program FilesMySQLMySQL Server 5.0inmysqld" --console 060323 12:18:24 InnoDB: Operating system error number 32 in a file operation. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html InnoDB: File name .ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. C:> Also while trying to install I cannot get the security setting to go thru, it give me the error 2013, lost server during query, I've tried to shut off my firewall and still the same, given access to port 3306 and still nothing.
Used Mysql On Windows Now Im On Linux Need Help!
Ok iv changed over to linux running ubuntu 6.06 after installing mysql i tried create a database i did "CREATE DATABASE forums" and got this: ./mysqladmin: CREATE DATABASE failed; error: 'Access denied for user ''@'localhost' to database 'DATABASE'' so how do i logging as root? on windows i just used the terminal thing but now i dont have that (well to the point where it asks you to login)
Does MySQL Work On Windows?
I've been trying to get 3.23 to behave on '98. MATCH seems very erratic, and FULLTEXT never works. RELOAD silently fails. Is it worth it to pursue MySQL on Windows?
Install MySQL 4.1 On Windows
I'm trying to install the 4.1 alpha binary version on Windows. After unzipping the download I don't find a setup.exe file.
MySQL 5.0.45 Windows Install
I am having an issue installing MySQL 5.0.45 on Windows 2003 (VMware). Basically, I extracted the contents of "mysql-5.0.45-win32.zip" to c: emp and double-clicked the setup.exe. However, the install wizard doesn't launch. I get a window with the install options via CLI.
Mysql Dump And Windows
I have installed mysql on windows. However, due to database corruption issues I would like to perform a backup every hour or so. As a result I plan to schedule a mysql dump at regular intervals(for example using the AT command). The problem is that the user that runs mysql dump has to supply the password. ie: myslqdump -u user -p databasename > backup.sql My question is: how do I specify (in a .cmd file) the password to enter after the mysql command above? I do not think "echo password" is enough for mysql to pick up the password.
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:
MySQL 3.23 Windows Access
I am trying to set up an Invision Board forum on my windows 2003 RC2 server. I have already set up and configured PHP4. I am now in the process of setting up mySQL. I have never used it, so you can imagine how confused I feel right now. I installed the 3.23 windows version on C:mySQL I do not know how to access it, nor really how to use it. The invision board is asking me to input SQL Database Name SQL Username SQL Password How do I createaccess this information. Thank you for your help. BTW: I recive this error while attempting to connect to my sql via cmd.exe "ERROR 2003: Cant connect to my SQL server on Local Host (10061)" I have two firewalls, XP's built in one and Norton Internet Security. Could this be the reason.
MySQL Slow In Windows NT4
I am running the Apache web server, MySQL v4, and PHP on an NT4 server. Apache runs great, but the auction software I am using (Web2035 Auction software written in PHP) is very, very slow. Sometimes it takes 20-30 seconds to bring up an auction page from the items table which has less than 200 records in it. Can anyone can give me some pointers on where to start looking? (I don't know if the bottleneck is with MySQL or PHP or what I might need to look at to enhance the performance of either package.)
Is Mysql For Windows Free?
I saw in a site that says "mysql for windows is free for one month to continue using it you must get a license". I was planning to use mysql on windows for company database I thought mysql windows version is free. Am I have to use on the linux for free solution?
Windows MySQL Questions
After installing on Windows XP, is WinMySQLAdmin.exe (WMA) the only way to start MySQL? WMA is supposed to add a user and password to the "grant" tables. Altho it does appear in the My.ini file, if I do this: Mysql -u root Use mysql; Select user,host from user; it prints: USER--------HOST (blank) build root build (blank) localhost root localhost Why does the user name that shows in My.ini not show here? (I cannot connect with that user name.) What is the "build" host? If MySQL is on a pc for development, and it has access to the internet, does the internet have access to the server? Do I need to be concerned about security in the same way as a web hosting server? I'm the only person who operates this pc. Does the statement "The MySQL server should not run as the root user." refer to Windows? If yes, how is it run as a non-root user?
Loading Mysql On A Windows - IIS
I have a personal web server (IIS) that i am trying to install mysql with...or install mysql so that it is available through my IIS server. I d/l it...now what? is there a GUI for mysql that i can use? a gui like access or something. if i create databases in mysql at home, how do i get them on a ISP server...
MySQL 4.1 Windows Binary
I can't seem to find a binary distribution of mysql 4.1. Can some one tell me if there is one and where to get it? Or is it not as simple as finding a setup.exe?
Installation Of Mysql 4.0.14 On Windows Xp
I am new to mysql server and trying to install the mysql server on my windows xp home edition. I have downloaded 4.0.14 zip file on my computer. I can unzip the file and it generates 10-15 files. When I do double click on the setup.exe it loads for 5 seconds and then stops. No window is displayed. No error message is generated. I thought may be I should try some other version. I downloaded older version 4.0.13 and same thing here. I downloaded 3.23.57 and same thing here. I am logged in as administrator. I can install other softwares without any problem. Can you please suggest any thing I should try to install the mysql server.
Mysql On Windows Servers
Will mysql work with microsoft server products? Does it lose any funtionality? Would it be better to use mssql?
Doubt In MySQL Windows
I tried to insert some large amount of text in mysql and used "Long Text" data type. But I am not able to insert a text that is having about 1.2 million characters in it. It is showing an error: "DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes". I used PERL script for database population and using Windows 2000 OS with pentium 2.4 Ghz Processor and 512 MR RAM. Anyone kindly tell me how to change the value for the max_allowed_packets variable in windows environment.
MySQL 4.1 With OpenSSL On Windows
trying to setup MySQL with OpenSSL support, I realized that I have to compile it my- self from the src package - where I've already glanced inside but found that there is very few info on how to build against OpenSSL libraries (planned to use v0.9.8a). Especially, I'm missing any Win32-related topics that are equivalent to the "./configure --with-openssl --with-vio" advice as required when building under Linux. 2 little questions: Will it be sufficient to put the OpenSSL .lib and .include folders into the compiler environment to obtain an SSL-ready version of MySQL? And, is there a chance to compile it with MS VC++ 6.0 Enterprise Edition (patched with all available support packs)? If not, I'll have to ask my colleagues if anybody has VC++ 7 on his machine.
Mysql And Windows 2003
------=_NextPart_000_0001_01C34BC2.26B3C4C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Wy can't I start the service in windows 2003 server have any one a solusion?
MySQL For Windows Problems
I need help installing MySQL on my Windows XP Home computer. I use the Apache 2 server and i have the newest version of PHP already installed, but I cant get MySQL to work. I used to get the error message about the 3.51 Driver being missing, so I installed the ODBCConnector 3.51 Driver, and now it says the Driver Version, Driver, API Level, Setup, and SQL Level on winmysqladmin instead of the error. But, when I go to start the server, the light goes green for about 4 seconds and then goes red again. I found an article here that said something about a connection string ( http://www.codingforums.com/showthread.php?t=22671&page=2&pp=15 ) but I cant figure out where that is or how I change it. Can someone please help me figure this out? :)
MySQL On Windows 2000
I am migrating my web enabled Access dbs to MySQL. I am using ASP on my development machine running Win 2000 professional with IIS and MySQL.When I attempt to run queries on my development machine, against the MySQL databases they run like a dog!! My Access databases flew compared to MySQL. I'm not expecting blistering performance, but it's taking minutes to access tables with under 20 rows.However, when I upload to my hosting company, everything is fine. Can anyone give my ideas how I can tune my developmet machine speed up the queries?
MySQL And Windows Firewall
I have a small network with a handful of workstations running off one server. (It's an older tower powered currently by Win XP...Upgrading soon to a new server, but until then I have to use what I have)All stations need and have access to MySQL. I use the default Windows Firewall install to help filter traffic to all other ports not needed. I also run our webserver (pages built with php and powered by MySQL) and SSL server from the same tower. So currently the only open 2 ports are 80 and 443. From both a networking and security standpoint, should I add MySQL to the exceptions list? Connections seem to work fine without it added.
MySQL 4.1 Windows Binary
I can't seem to find a binary distribution of mysql 4.1. Can some one tell me if there is one and where to get it? Or is it not as simple as finding a setup.exe?
Windows Mysql Backup
what the command is to backup a mysql database on windows. I tried to do a search for this in the forms but I kept getting error 404.
MySQL MS Windows GUI Data
I am learning starting to learn the MySQL software. I need to know is there a end user interface tool, like MS Access, which I can use to create/delete tables, generate reports, and allow end user to input datas in GUI application.
MySQL Compile On Windows
First time I entered in VS as a VC++ 2005 workspace. I opened mysql.dsw from the source package version 5.0.19 [general release]. At the beginning, it asked me if I want to convert this project from an earlier version (2003 I suppose) to VS 2005, I sayed OK... then, all kinds of error messages appeared: Cannot load the project due to a corrupt project file.
Installation Of Mysql 4.0.14 On Windows Xp
I have downloaded 4.0.14 zip file on my computer. I can unzip the file and it generates 10-15 files. When I do double click on the setup.exe it loads for 5 seconds and then stops. No window is displayed. No error message is generated. I thought may be I should try some other version. I downloaded older version 4.0.13 and same thing here. I downloaded 3.23.57 and same thing here. I am logged in as administrator. I can install other softwares without any problem. Can you please suggest any thing I should try to install the mysql server.
Windows Service For MySQL
Im trying to install MySQL on a XP Pro SP1a machine. It wont start the service from the installer. I go to start the service manually, and it fails as well. It says "Error 1067. The process terminated unexpectedly."
|
TRACKER
