MYSQL :: Sharing Database Tables Between Windows & Linux

Using Database In Windows By Linux
I am hosting an intranet on a machine with dual boot in both win98 and
RH9 Linux. the intranet was first set up and running in win98. I have
a mysql database in the win98 . The win98 partition is mounted in
Linux and is accessible. I am duplicating the intranet in Linux. the
HTML pages are accessing from the win98 partition. Is there a way to
use the database as such by the intranet in the Linux.

Can A MySQL Database Be Shared Between Windows And Linux?
I've got Windows and Linux running on my computer, on seperate partitions. I also have a shared partition for stroing files, and can be read and written by either system.

I also have MySQL installed on both systems. When I make changes to the database in Windows, I have to do a dump of the database (or single tables) to a text file on my shared partition. I then have to switch into Linux and load that file into MySQL there. This is a bit of a hassle.

Is it possible to somehow store the database file on the shared partition, and use the same database from both OSes? This would be very convenient, since I wouldn't have to maintain two copies of the same database!

Moving Mysql Database From Linux To Windows
I have to move my mysql 5 database from linux to windwos system. Can this be done by moving files from data folder or do I have to dump the data then import it back to new system?

Sharing MySQL Install Between Multiboot Machines (windows)
On Windows, I multiboot W2k, WXP. All 2 have MySQL install but in different
directories and partitions. I (unfortunately) also have 2 instances of one database.

Is there a way for MySQL to share a common installation and database?

I suppose it is possible. If so, and if I install MySQL in W2K first, what are the steps to
import the database install into XP?
Will I need to install in XP again, and just import the databases? Or just create a
windows shortcut to database directory so it's automaticaly imported into XP MySQL?

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.

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?

Windows Vs Linux
We currently run our MySQL on linux. Could someone advise me on the watch outs on moving MySQL to windows and also if there is any performance loss as a result?

From Windows To Linux
I've got a production MySQL database running on a Linux server, but do my development on a Windows laptop.

I recently overhauled an existing app and needed to write data conversion routines in order for my existing data to map to some new data layouts.

I'm running the conversion on my laptop, so I don't mess up the existing production data. I will be running some tests in parallel before going live with the new app.

When I run the conversion, Windows sets all the table names to all lower case. So when I load the data to my Linux box, the table names are all wrong.

Is there anyway to force MySQL to maintain it's case on a Windows machine so that I don't have discrepancies from one OS to another?

Windows Or Linux?
I am developing a website using php, MySQL and Apache on my home pc which uses WinXP. I am pretty sure that I will not be able to find a web host who will support Apache on Windows, so I guess I will have to go for one that uses Linux. If I do this, is there a serious difference between the way I need to write the PHP code, or is it just the same.

Mysql, Linux Or Windows?
Does mysql work on windows or it has to be on linux only?

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)

Windows To Linux Server
I am trying to set up a a Mysql driver on a linux server from a windows machine. I get the following error.

[MySQL][ODBC 3.51 Driver]Host '(server number)' is not allowed to connect to this MySQL server

Is it likely that the windows-linux combination is causing a problem here?

Mysql, Linux Or Windows
Does mysql work on windows or it has to be on linux only?

Windows And Linux Versions
I would like to know what are the main differences between windows and linux versions of this DB system.

I´m using it on linux but i´m planning to migrate to windows...

Is there any performance difference? Is it as solid as linux version? It´s of free use (under GPL) ?

I made a test here in windows and it seems to work well..

How To Copy InnoDB From Linux To Windows
I am trying to copy an InnoDB Database (mysql) from a linux system to a Windows XP machine.. I copied the files under /mysql/data/mydatabase/ files to the same one on my windows machine, and I copied anotehr 3 files from the the /data folder which I read about in mysql.com (indata1, and two log files)...

All the database worked expect for the child tables (that has relation with other tables)..

Did I do anything wrong, or is there another way to transfer the database..

Is MySql Syntax Different On Windows Vs. Linux?
On our team, we're working on a database. One copy is on the PC. The other copy is on Linux. I wanted to send a new table to the Linux guy. I went into MySQL Query Browser, did a "Copy CREATE statement to clipboard", and pasted the SQL code into a new email and sent it to my Linux guy. He tells me that the code fails every time. Here's what It looks like:

Connection Problem !!! Windows To Linux
I wrote a program application for windows which can add and delete data
from this application, it working fine with my own MySQL install on the
same windows OS.. Now I try to change the connection this dayabase to
the server whihc runnign under linux, and create the same database, same
user and password. But when I connect the error message said:
[MySQL][ODBC 3.51 Driver] Host'219.95.155.119' is not allowed to
connect to this MYSQL Server.

But form the database, I added the host "%", means hsould be allow any
host... anyone can help me on this? the application I wrote will be
using with dynamic IP everytime user dial-up to the internet connect.

Updates Invisible - Windows Only (Linux OK)
I have one Java app writing records to a database (App A) and another,
a Java web application running under Tomcat, displaying the records.
Call this App B.

When I first log into App B and get a connection, all records in the
database at that point get displayed OK.

But after that, any new records inserted by App A do not get displayed
when I refresh (running the query again).

If I log out of App B and log in again, getting a new conection, I see
all the new records.

This behaviour only occurs if I'm running on Windows. If I run the
database on my Linux box with the same application code, new records
inserted by App B are immediately visible to App B with no need to
close the connection and open a new one.

Moving MySQL From Windows To Linux
Is it possible to develop a database on Windows and then copy it to Linux? In Oracle it's not possible to simply copy the database between platforms, I just wondered if MySQL is the same.

Query Behaving Differently In Windows And Linux
I have a query to find the blog entries that are most commented:

SELECT blog.*, COUNT(blogcomment.id) AS cnt FROM blog, blogComment WHERE blog.ID=blogComment.BLOG_ID GROUP BY blogComment.BLOG_ID ORDER BY cnt DESC

The query works fine on my development machine running Windows mysql 5.0.22 but on my Linux server running the same version of mysql (5.0.22) I get the following error:
#1054 - Unknown column 'blogcomment.id' in 'field list'

Any ideas why it works differently on the two servers? Suggestions on a better written query is ofcourse welcome too

Access Linux Mysql Server From Windows?
Can I run a Mysql server on a linux box, and access the databases belonging to it over a lan from a machine running windows xp?

Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the
site performance is very slow on windows. I dont know the exact
reasons.

I have seen some benchmark details on internet. But still they are not
having concrete facts to support LAMP as a better alternative to WAMP.
Allmost all the search done on google melts down to IIS vs Apache, My
main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly
for PHP/MySQL.

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 .

MySQL/Linux Tables Case Sensitive
I have moved an application that we have written from running on Windows with SQL Server to running on Linux with MySQL.

Since I have moved the application I am finding issues as MySQL/Linux seems to be case sensitive with how table names are referenced. In SQL Server you can use SET IGNORECASE TRUE to force it to ignore the case.

Is there anyway to do this in MySQL/Linux?

Mysql Linux To Mysql Windows
i have been running mysql on rehl4 and now the powers that be want to move the databases to a central windows 2003 server running the windows version of mysql.

how on earth do i import my dump file in the window version? i am familiar with doing it in linux but i cannot figure out the mysql command line tool that comes with the windows package.

Sql Database From Linux Fedora's Shell
How may I restore *.sql databases from linux shell?

I've read the use of mysql command I don't have installed.
This is a remote server with preinstalled Apache-php-mysql.

Disappearing Tables In Windows 98
I think I have experienced this with 3 different computers. I'm not
sure, but I think all of them were using Windows 98 and MySQL version 3.x.

The problem is that some of the tables disappear from the database,
usually the tables that have most of data have disappeared so I think it
might be a bug in Windows 98 file handling.

Has anyone else experienced this or similar things?

Windows Based GUI To Manage Tables
What is best GUI to utilize to connect to my db to make edits to tables, etc...?

I thought MYSQL Administrator could do it but I can't connect to my database on a shared server... if this is to the right tool.

How Do I Create A Database On Linux Machine Running Mysql?
I have an sql script file that is supposed to create
a set of database tables for me. Supposedly I type
the following on my linux box and its all supposed
to work...

mysql (ENTER)
. mysql_dump.sql.txt

When I type myslq <ENTER> I get a command prompt
that looks like this...

mysql>

But I don't know how to change directories from that
command prompt to the directory where mysql_dump.sql.txt
is located. Can someone tell me how to change dirs at
the mysql> prompt?

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.

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),

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 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. )

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?

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. )

Mysqldump Database Using Windows
I am trying to export a mysql database on a windows machine. I have tried using mysqldump command: 'mysqldump db_name [/path/to/new_directory]'

through my mysql command line client but it does not recognise the command. Any ideas where I am going wrong?

Moving Mysql Database From MAC To Windows
I have to move a database from a MAC with MYSQL to Windows. The MAC has MYSQL 4.0.18 loaded.

The phpmyadmin is not working on MAC machine so I tried to just copy the database files to the Windows machine mysql 4.0.21

After this mysql crashes when I try to open the databases with phpmyadmin.

A popup window appears and called DBUG Test signal Confirming this message causes mysql to fail.
In my phpmyadmin it get the message server not responding.

I also tried to recreate the empty tables on the Windows machine and just copy the .MYD and .MYI files into the Windows machine, leaving the .frm files. This worked on some tables but on others I have corrupted data in it and some tables are shown as in use.

The MAC mysql database does have 2 files that the Windows doesn't. ._.DS_Store and ._DS_Store.

Are the MYSQL files for those 2 system not compatible? If not How can I convert the database files? The database is still working on the MAC so I do not think the database is corrupt.

Move Database In Windows To Different Directory
How do I move a database on a Windows 2000 server box. I have MySQL and found where to point the database in the MY.ini file but I cant seem to move it to another partition. If I change the path in the my.ini file the mysql service fails to start. Any help would be greatly appreciated.

I have seen how to do this in unix and linux on this forum but could not find a thread on how to do it in Windows.

Creating First Database On Mysql 4.0.21 Apache 2.0.52 Windows Xp
started mysqladmin 1.4 then i started mysql monitor by clicking on it in the mysql folder and tried to create a database like this

mysql> create database testdb;

mysql>got error error 1044:access denied for user: '@localhost' to database 'testdb'

do i need to set up a user or is there like a default user sign in i need to do? or some kind of configuration i have missed?

How Can I Access Mysql Database Running On Windows Pc
How can i access mysql database running on windows pc from linux server, on both machine i am using mysql 5 and perl 5.8.8 , ip of windows machine ie. 192.168.0.50 and linux server has 192.168.0.10 on single LAN.

InnoDB Tables And MyISAM Tables In ONE Database?
My application demands some advantages from InnoDB and some from MyISAM.

Is it attainable to have both InnoDB tables and MyISAM tables in ONE database?
Or else, getting views from two databases, one from InnoDB and the other from MyISAM?

If not possible, any other approaches will do the job?

100 Databases, 4 Tables Each, Or 1 Database, 400 Tables
I was able to build, tweak and do whatever necessary to establish a rather different project but am worried that it may sooner or later crash due to idiotic programming / database usage.

In essense I took 1 database with 4 tables and duplicate it 100 times BUT because I need to connect to the different tables within the php script and am not experienced enough to created nested database connections, I duplicate the 400 tables within the same database.

What I want to know from a MySql perspective, would it make any difference if the script "play around" with 1 database connection and 400 tables or would 100 databases with 4 tables each be better? (Maximum database queries to only 17 tables at a time)

Database Tables
I have a web program where I want to connect to my database and
discover the tables within the database. Then select a table and
discover the column names, their types, and lengths.

Database With 100.000 Tables
How can I dump a database with 100.000 tables?
Right now I got this error:
mysqldump: Got error: 1105: File './usr_web20_4/hilarypics_usergroups.MYD' not found (Errcode: 24) when using LOCK TABLES
the amazing thing is that the table exists and that the error occures one with this, another
time with anohter table.
I read something that solves the problem by increasing the max amout of tables
to be opend set to default to 1024 in the mysql-config file

Database Tables
I am a newbie and use the PHP admin interface with the SQL database. I would like to populate tables of the database from an Excel text file. I keep getting error messages. Does anyone out there have any experience with this?
I appologize if this has already been addressed. I searched the forums and did not find this info.

Sharing Database Tables Between Windows &amp; Linux

Sharing Database Tables Between Windows & Linux