MYSQL :: Sharing MySQL Install Between Multiboot Machines (windows)

Migrating Mysql Servers Between Windows Machines
I just had to do a mass data switch to my windows server.It's been running apache with php and mysql for over a year now.

This data switch meant i just copied the files over to an almost exact copy of my current windows installation.Unfortunatly mysql didn't startup the way everything else did.Now the server won't start at all(dies on startup.) If anybody knows any problems that would probably result from migrating MySQL i'd be highly appreciative. Short of that,how can i find the errors mysql is having,thus allowing me to diagnose a solution the problem.

Sharing Database Tables Between Windows & Linux
I'm new to MySQL (using v4.1) and have a dual boot machine with Windows and Debian Linux (Etch).

My goal is to share a table named "wordpress" between Linux and Windows by storing it on a FAT32 mount (I realise this limits me to 4GB in total).

From what I can see at the moment, the "wordpress" tables live under /var/lib/mysql/wordpress.

Numerous searches have revealed how to backup data, but I haven't seen any clues on how to permanently reloate a database to another location.

JOIN Issue On WIndows Install But Not Linux Install
I am using MySQL 5.0.15 on windows and cannot run this query:

SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a, building b
LEFT JOIN users c ON a.createdby=c.id
LEFT JOIN users d ON a.modifiedby=d.id
WHERE a.sortcode=b.sortcode AND a.sortcode like '1,2,1,6%' LIMIT 0, 25

I receive:
ERROR 1054 (42S22): Unknown column 'a.createdby' in 'on clause'

But this query DOES work under my linux 5.0.0-alpha!

I can modify the SQL Statement to the following and it works fine:

SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a
LEFT JOIN users c ON a.createdby=c.id
LEFT JOIN users d ON a.modifiedby=d.id
RIGHT JOIN building b ON a.sortcode=b.sortcode
WHERE a.sortcode like '1,2,1,6%' LIMIT 0, 25 .

After Install Cant Select Install As Windows Service
i cannot configure MySQL to install as a windows service. NOR can i get the blasted thing to let me setup a user name and password. how do i correct this ?

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.

Install On Windows XP
I cant get mysql to run on my winXP computer. I have downloaded it and
installed , unzipped and run setup.exe and placed it in c:mysql.
I type the command to start the mysql server
c:mysqli mysqld --console

It opens the console and then the console shows some inoDB commands and the
console hangs.

I followed the mysql manual and i cant find the answer
there is no command prompt and nothing...how do I run mysql?

Install My SQL In Windows XP?
Can we install MY SQL in Windows XP? I tried to install but it gave error "This enterprise server sersion is not supported by this OS. Only Client version will be installed".

Need To Install MyODBC 3.51.14 On Windows Client
We have recently upgraded the MySQL client on a Windows machine to 5.0.38. In concert with that upgrade, we must ensure that MyODBC 3.51.14 is properly installed, as well.

After executing searches on the mysql.com website, I cannot locate guidance for the following issues:

1) To what link do I navigate to download the MyODBC 3.51.14 installation files?

2) What must I do to the client machine to prepare it for the 3.51.14 installation? (e.g. uninstall the old MyODBC driver?)

3) What specific steps do I follow to successfully install MyODBC 3.51.14 on the client machine?

First Time Install On Windows - Admin User&password Problem
I have a problem with logging in to MySQL. Access denied.

I think the issue is with the host, user and password settings. I assumed you had to add this information to the my.ini before you started the service for the first time. Is this only for WinMySQLAdmin? Is there a default?

I have tried all the solutions I could find but they seem to all require user privileges in the first place.

I simply need to have one main admin user and password and to refresh their values to be certain of the new settings in case there was one before.

Sharing A MYSQL Database
I tried searching for information, but didnt exactly know where to look, meaning which keywords. I did try though hehe

I have a site (or am building) that hosts free accounts for stop motion projects. Now I am developing a script so that everybody can upload movies and stuff to their own account ( which is a subdomain name with their own database and stuff). I want that database to be one main database. I could of course set up a new database and tables for each account, but that would be VERY time consuming... (unless anybody knows an automic way of doing it.)

My question is:

How can I create a script that can be put on their site, but accesses the database of the main site. I cant just put the username and password in a config.inc.php file on each site, cause then they can all access MY database and fool around with it.

MySQL ConnectorJ And Remote Machines
Let's say I have a MySQL 4.12 database, opened to the internet on
111.111.111.111 allowing all incoming and outgoing ports. I have a username
and password setup, which CAN connect to this database, from
222.222.222.222.

Also on 222.222.222.222, which is running Tomcat, I have a Java servlet,
called, say, servlet.class in WEB-INF/classes. servlet.class has permissions
755, as does WEB-INF/classes.

Additionally, I have on 222.222.222.222 under WEB-INF/lib
mysql-connector-java-3.1.7-bin.jar also with permissions 755.

The system (222.222.222.222) is running on Linux Kernel version
2.6.9-22.0.2.ELsmp. I am running Java 1.5.0_05. Bear in mind, the very same
parameters, from the same machine (222...) connect to the very same db
(111...) under php (so there is no firewall issue on 111...). Additionally,
if I run a MySQL DB (version 4.0.25) on 222... and connect to it (thus, on
'localhost') I can connect no problem. It is only when I go to connect to a
remote machine that I get the following stack trace: Code:

Replicating Mysql DB To Local Machines
We have an application written for a PDA that we are switching from MS
Access to Mysql. There is a central server that has all the data in a
mysql database, however when we sync from the PDA it is much faster
sync'ing to a local copy of the mysql database then on central server
(users are remote and must VPN into server).

What are the options for taking a larger mysql database and segmenting
out data for a particular user (a subset of total data) to their local
machine? Is mysql replication a good option or is there some other
technique?

Sharing Data Between MySQL And SQL Server
I have a client who is using SQL Server for a database over 3 geographically diverse locations. Each location has a copy of the database which is updated constantly across their WAN.

I have a single location MySQL database

We have a need to share one table between the two structures.

Is there any way that MySQL and SQLServer can share and mutually update a table between the two.

( I can't just leave the data on their server because if they take their db down, for whatever reason, the missing table will cause serious problems and effectivly shut down work on our operations. )

Question About MySQL Performance On 2 And 4 CPU Opteron Machines
We ran MySQL (4.0.15-standard, 64-bit, SuSe 8.0) benchmarks
on 2 CPU and 4 CPU Opteron machines. Mostly we tested insertion
times with many simultaneous connections (hundreds). To our
surprise we did not find significant differences.

Each of our servers (2 and 4 CPU machine) has one 1Gbit network
connection. I have feelings that the machines are the network
bounded, not the CPU bounded. Could it be true? How to verify it?

Can't Hit From Outside Machines
I'm migrating my Apache/MySQL/PHP box from Windows to Unix... and now the machines which hit the MySQL database no longer seem to be able to access the MySQL databases.

The server is all setup, I'm running phpMyAdmin on it locally and all my local php scripts work fine, but a couple machines hit MySQL from the outside...

One example is a PHP script, and it gives me
CODEWarning: mysql_connect(): Can't connect to MySQL server on 'devcentral' (10061)

Querying From Different Machines
I have databases on two different machines which I want to select from in one query, any good way of doing this without moving tables from one machine to another?

Replication On 3 Machines
I have 3 machines M1 M2 and M3, i need to setup the following:

M1 is the master
M2 is reading from M1
M2 is a master for M3
M3 is reading from M2

The problem i got, is when i run a command in M2, it's replicated in M3,
but when the command is being run in M1, it's replicated in M2 but not in
M3. does anybody know how i can fix this problem?

TABLE SHARING
i need to share a table between SQL Server 2005 DB and MySql DB. the table is on on SQL Server 2005 DB and i want "watch" it in MySQL DB.

Sharing Table
Is it possible to share a single table between two databases? For example, I want a single seller table common to a database about houses for sale and a separate database about land for sale.

Spanning DB Over Multiple Machines
Can MySQL v4.0 be setup to have a single database span multiple linux machines?

Entities Sharing A Look Up Table.
I have created a "country" lookup table, and I have two different entities that both have a "country" field in their respective tables. My question is this:

Are there any disadvantages in having two seperate entities pick up their relevant countryname from the same country look-up table? Is it even allowed? And lastly, as the country table doesnt contain any other fields, the country field acts as a primary key on it's own, correct?

Sharing Data Across Two Databases
I am having trouble deciding how to best handle this situation. I have two separate applications each with their own database, but would like for them to share the same user account information. If a user registers for one application, they should also have an account on the other application.

Using views to share the same user table across both databases is not an option as I am using MySQL 4.

Any suggestions on how I should best handle this?

Sharing A Database Between Two Servers
I have 2 harddrives, one with linux and windows, and the other holds all my php and sql databases. I set up the databases with windows and everything is fine. Now I want to be able to just have the linux version of mysql look at that same database on the second harddrive and work with the database. The error I get is "Can't open file:

'**.ibd' (errno: 1): "** being any of my tables. Is it possible to configure them to work together in anyway? I dont want to manually have to dump the database and then reload it every time i switch between the OSs... any suggestions?

Sharing Login Details
There is no decent image gallery that can be put with Joomla or Mambo CMS so I am wanting to add a separate pop up page to use a 4images (http://4homepages.de) image gallery.

HOWEVER,

I don't want my users to log in twice to two different databases!

I'm sure there is a way of doing this. (both the CMS and the Gallery are on the same server, and they can both use the same Database.

Sharing Login Details
There is no decent image gallery that can be put with Joomla or Mambo CMS so I am wanting to add a separate pop up page to use a 4images (http://4homepages.de) image gallery.
I don't want my users to log in twice to two different databases!
I'm sure there is a way of doing this. (both the CMS and the Gallery are on the same server, and they can both use the same Database. )

Install / Re-Install MySQL 4.x
1. If I want to simply run MySQL on my RedHat Linux server (Intel) based which product to I install?

2. I have paritally installed MySQL once. Had some problems. Now that I am trying to Re-Install, it says that I cannot because previous components exists. How do I uninstall MySQL?

Enable Root Access From Remote Machines?
I just setup MySQL5 on a Windows 2003 dedicated box and one of the last questions in the Instance Configuration Wizard had a check box labeled: "Enable Root Access From Remote Machines".

I did some research but could not figure out what that meant. I log on to my box using Remote Desktop so if I don't check this will I able able to have root access?

I am guessing this is a security issue. I want my box to be as safe as I can.

Here is how I have the MySQL config file setup (from the Instance Configuration wizard):

port=3306
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
default-character-set=latin1
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=49M
table_cache=256
tmp_table_size=52M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=103M
key_buffer_size=76M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_data_home_dir="C:/MySQL Datafiles/"
#skip-innodb
innodb_additional_mem_pool_size=4M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1524K
innodb_buffer_pool_size=148M
innodb_log_file_size=30M
innodb_thread_concurrency=8

Sharing Data Across Multiple Sites
Sorry if this has been addressed on this board, but I am getting some serious Hour glass action, when I attempt to search this board.

I am attempting to put multiple sites together that utilize one common database with common tables. I wanted to get some advise on how the table can be implemented efficiently.

The concept is I have multiple sites that share the same code and database. I will assign a site ID to distinguish between the sites. Some Article data will be shared across the sites. Example: I have a site for Bass Guitar, Lead Guitar, Keyboard, Saxophone, etc. A component of the site will be articles written about music theory, that can span all these sites. How can I implement a solution that allows One article to be placed on all these sites based on the site ID.

I was thinking of one of two ways (and ofcourse there might be an even easier way, i haven't thought about)

Option 1
Having a field in the database named after each site or siteID, and in my query having a WHERE Clause in the code based on the siteID ie: "WHERE Bass = 1" for the bass site, and on the Saxophone site the same code would be there "WHERE Sax = 1" that way on each site If the article has a 1 in the field, it would display. I don't think it is efficient and if I where to use this concept across a large number of sites, it would very quickly become a nightmare to maintain.

Option 2
Having a field that receives a comma delimited data, that can be parsed with SQL and displaying the results if the data is present. With option two I do not know how to do it with SQL any insight? Is this efficient?

Active Enable Root Access From Remote Machines
Who i can active the option "Enable root access from remote machines" in the files of configuration of mysql 5.

New To Mysql Install
i installed mysql and its a weird program, "WinMySQLAdmin 1.4".

Anyways I got phpMyAdmin also, and I guess I just drop it any of my
virtual host folders and it works with the MySQL software.

I get some security warnings, Im not too concerned because this is for practice.

If i make a new DB in phpMyAdmin it doesn't show up in WinMySQL Admin software. The only one that shows up is the one called "test" that I made in command prompt. This seems kind of confusing, but is there a way I can just make this phpMyAdmin work with WinMySQL Server?

I dont know if its a REAL database if its just appearing in phpMyAdmin, this stuff is really confusing to install, I just want to make databases and work it with php, not become an installation expert

Cannot 'USE Mysql' In New 5.0.45 Install On Mac
After a new install on a Mac, I cannot USE the mysql database. Even though I cannot USE it, I can select from it.

Sean
====================================

$ mysql --user=root
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 6
Server version: 5.0.45 MySQL Community Server (GPL)

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.00 sec)

mysql> use mysql
ERROR 1049 (42000): Unknown database 'mysql'

mysql> select User,Host from mysql.user;
+------+-------------+
| User | Host |
+------+-------------+
| root | 127.0.0.1 |
| root | 174.6.1.4 |
| root | localhost |
+------+-------------+
3 rows in set (0.00 sec)

How Do You Install Mysql?
I'm very new to this and I've been trying to figure this out for a few weeks now. Theres not many sites that tell you step by step what you need. I have a host that im trying to put phpnuke on. My understanding is that i need to install mysql, phpmyadmin, and then phpnuke. I also understand that you need to configure it. Could someone tell me how to configure the files step by step? It is a linux server.

How To Install MySQL 5.0.37
Please anyone explain step by step to me how to install MySQL 5.0.37 ? I downloded "Windows installer" and "Mysql noinstall 5.0.37".My platform is .NET 2005 with Windows XP professional.

Which one is first install? i want to my syatem act as a server and other three systems as client.

New Install Of MySQL 4.x
Hopefully there is an easy solution to this. I have an older version that seems to work with the same settings. I have install this copy on Windows XP. I created a server
called:

Name:  DEVSQL
Host Name: localhost
User Name:  root
Password:   blank

I am using the MySQL Control Center.

It states: Connection added successfully.
But when I attempt to connect it states:
[DEVSQL] ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

I am starting a new project and I need to use this current version of MySQL.

Any suggestions would be appreciated. I have downloaded the MySQL driver and installed it.

Install & Use MySQL
I'd like to create a FORUM site for an existing web site and would like to use mySQL for the database. The existing web site currently uses MS Access DB and it's working well. HOwever, for a FORUM site, I believe I will need a more robust DB management system.

Is There A Right Way To Install MySQL?
I want to create a web application in Dreamweaver with MySQL, PHP and/or Coldfusion. Is there a right way to install these into my Windows XP system, I mean should I install first MySQL followed by PHP and Coldfusion? Also, should I install Apache also? What about IIS? And last, it is better to run Apache with PHP or ColdFusion with PHP.

MySQL Install
I just installed MySQL on a Windows XP machine, and upon using the SHOW
DATABASES command, I was suprised to see that the only table that exists
is the 'test' table. Isn't there supposed to be a 'mysql' table there
also? Did I miss something?

Install MySQL 4.0.x For PHP
I've setup MySQL on Windows several times and figured it would be relatively straightforward on Linux;)

I have RH9 Linux installed, and have successfully upgraded both Apache 2 and PHP 4 to the latest versions.

I compiled PHP with MySQL.

Okdoke, now I couldn't get MySQL 3.23.54a-11 which comes with RH9 to work - I think I was just being dense...

So I then did the following (even more dense of me!):

1) Tried to rpm -i mysql-server-4.0.18-0
// This failed complaining: "MySQL-server... conflicts with file from package mysql-3.23..." lots of times

2) Tried to rpm -i mysql-client-4.0.18.0
//get the same error as point 1 above.

3) (really dumb on my part here) I did rpm -e mysql-server-3.23.54a-11
// I thought this would clear up points 1 and 2 - d'oh!

4) (getting even dumber...) I did rpm -e mysql-3.23.54a-11
// This wouldn't go through as mod_auth_mysql and php-mysql need it as a dependency.

I am now left in the very self-inflicted state of having only half of MySQL 3.23 installed, none of 4.0, and am unsure if any MySQL is currently working with PHP 4.

Where I would like to be is with either MySQL 3.23 or MySQL 4.0 installed, running, and accessible to PHP. I will need to alter PHP to not use the built in MySQL as the make of PHP informed me that I should use an external version of MySQL if using it with non-PHP projects.

Mysql RPM Install On FC4
I have just installed MySql 5.0.18 on a fresh installation on RH fedora core 4 using RPMs but the service won't start. Any ideas, can I see a log of why its failing anywhere?

Cannot Install MySQL
I've just downloaded the latest version of MySQL form mysql.com (4.0.21) and unzipped it then ran setup.exe. In theory that brings up the install wizard.

Mac (OSX) Can't Not Install MySQL
If i click on the link at THERE ARE DIFFERENT results:

Here is result #1

I get a message...........

"Internet Explorer does'nt know how to handle the type of file you have selected. You can choose to save this file to your disk or you can configure a helper application."

Hre is result #2

I get message............

The file "mysql 2" does not appear to be compressed or encoded. The application "StuffIt Expander.app" might be able to open this file. Would you like to try opening the file using "Stuffit Epander app"?

- I try over and over and the above message keeps poping up!

Here is result #3"

I get message............

"Couln't open the file "mysql 2" because it is not a file that QuickTime understands"

Cant Install Mysql
Every time I run the mysql instance config.exe it stops at the 3rd step and it says " can not create windows service for mysql. error 0. I have no idea what this means and why I'm getting this.

MySQL Install
It installs (at least it seems so) ok, but I never have "access" to the database. It always says "Access denied for user: '@localhost' to database 'mysql'

This is not on a network, but on a laptop for myself. No one but me uses it and like I said, I am only setting this up for educational purposes (not real use). I can see the two tables, test and mysql, using 'mysql show'...but cant really do much more.

I started the Admin GUI tool to look at the .ini file, and it has HOST=Jaret, my username and then my password. I tried logging on with these values but it never works.

Install MySQL 5.0
im only using a personal PC at home.. is it ok if install mySQL even w/o connection to network?

Re-Install MySql
I want to put a MySql database on my network file server.

Right now I have it on my local workstation and I been writing a VB .NET application to access the local data. Now I need to start testing it on the network.

Do I have to reinstall MySql to get the data files on the network computer?

MySQL/PHP Install
Forgive me if I'm being an idiot, this is my first time installing anything on Linux (RedHat 6.2).

I successfully installed MySQL (3.23.32) using the rpms (I created a test db that works fine). Now I'm trying to install PHP (4.0.4pl1), but configure gives me the following error: cannot find [mysql] header files under /usr/bin. I'm using the option --with-mysql=/usr/bin because the rpms installed everything there, instead of /usr/local/mysql, which is where I would have installed it if given an option. Poking around I found the header files in /usr/include/mysql, so I tried to specify the option --mysql-includes=/usr/include/mysql, but configure says that's an invalid option.