Trying to replicate MySQL 4.1.1 databases into MySQL 5.0.17. I am able to replicate one database perfectly, but I want to replicate multiple databases.
202989
I don't see the problem.  If you can replicate one database, you should be able to replicate multiple databases.  Maybe at quick look at this will help:\n\nhttp://dev.mysql.com/doc/refman/4.1/en/replication.html\n\n...or this one:\n\nhttp://www.oreilly.com/catalog/hpmysql/chapter/ch07.pdf
596601
certain databases like mysql achieves this by using the dot operator "."\nsay db1 has table1(field1) and\ndb2 has table2(field2)then \n\nselect a.*,b.* from db1.table1 a,db2.table2 b where\na.field1 = b.field2
285909
Do you get a blue screen saying anything? Sounds like a driver or IRQL mix-up. Any recent changes? Did you run a good anti-virus prog like AVG 7.1? Need more info to help you.
213019
Sounds like your table lacks a primary key.\n\nIf it does have a primary key, you should check the lock you are using; you're probably using an optimistic lock on a database that others are updating, while you really need to use a pessimistic lock on the records you want to modify.
68393
Yes, make sure you have all the correct entries for your database. It will not be root@localhost unless you are running it off of your own personal server. If you are not sure of your username, password, database address, ask your database provider for the info.
624981
Hi,\nI am database programmer and use MS Access and SQl and others. Give a detailed example what you exactly want to do. Then I will tell you the design. I never designed a database wrong until now, hehe.\n\nA very important tip for you! If you want later export the database to SQL do NOT use the export wizzard of Access. This wizzard does not work and cost only time. Use the Import Wizzard in SQL. This wizzard works. \n\nNice greetings\nFranky
482305
You can use a freeware version of SQLyog tool from http://www.webyog.com/.\n\n1. You have to first register both you production server and the development server.\n\n2. Make a connection to both servers\n\n3. Create a blank database on prodction server (in case there is no database on production server).\n\n3. Right click on the production server database and select the 'Copy databases to different Host/DB...'
83092
I'm not familiar with the Yahoo Small Business implementation of MySQL but if you can run SQL commands you can always "DROP" any tables you don't want anymore.\n\nCareful with that command, it will delete the table permanently.
618385
Sure, it's easy to use.\n\nSee http://www.connectionstrings.com/ for an example of a MySQL connection string.\n\nGo to http://dev.mysql.com/downloads/connector/net/1.0.html to download a .NET MySQL connector.
50609
Hi, this gets tricky. The issue is having to have multiple logins. Depending on your forum system, you may be able to get a database driver that will merge the logins... link below is to some free gallery software that is not too hard to install and has loads of features. It does take a while to set up how you want it, but thats half the fun.\n\nhope that helps..
506058
u have problem with line 19....check it....better use php with mysql
600035
Do you get an exception error?\n \nI would need to see the SQL statement to see what is wrong with it. If it is executing the query, but you dont see the changes, then there is something wrong with the SQL statement.
606741
I think u have to enter you host name, username password and the name of the database after the =>.\n\nyou can do this wich a text editor like notepad.
173077
See the reference below.  The documentation has some examples. \nFailing that MySQL has a C API which you could use from C++.
760
Hello,\n\nLooks like you need to add a 0 to the end of the rating_sum row and the script will execute. So edit the mambo.sql file located in the SQL folder by adding a 0 at the end of the rating_sum row see below:\n\n`rating_sum` int(11) unsigned NOT NULL default '',\n\nto \n\n`rating_sum` int(11) unsigned NOT NULL default '0',\n\nI think your local MySQL install is being picky. \n\nTry it out and let me know, if that works. \n\nThanks,\n\nV
639806
Here are links to two utiliites that can correct exchange DB errors.  At different points in my career I have used them.  I would do Isinteg first, but keep in mind that when a database is being fixed that some data will be lost.
123382
Your SQL install is bad, since libmysql.dll is basically all the libraries used by MySQL.