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.
View Complete Forum Thread with Replies
Related Forum Messages:
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.
View Replies !
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!
View Replies !
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?
View Replies !
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?
View Replies !
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.
View Replies !
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?
View Replies !
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?
View Replies !
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.
View Replies !
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.
View Replies !
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:
View Replies !
Slow Connect Linux To Windows MySql
I have a Linux box with the latest MySql and another box (Windows 2003 Server) with the latest Mysql. From the unix prompt I do this: mysql -uroot -pmypass -h windowsserver mydbname this take about 4 seconds to connect I do the exact same thing on a windows workstation and its connected instantly.
View Replies !
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
View Replies !
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.
View Replies !
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 .
View Replies !
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.
View Replies !
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.
View Replies !
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.
View Replies !
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.
View Replies !
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?
View Replies !
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?
View Replies !
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?
View Replies !
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?
View Replies !
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?
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 !
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.
View Replies !
New Timezone Tables For Windows Build?
I'm trying to setup MySQL so I can use the "CONVERT_TZ" function. To do this I need the timezone tables installed, but as I'm running on a Windows server, my only option is the pre-generated tables, which are now out of date. In particular, they have incorrect daylight savings data for my local region: Australian Eastern Standard Time. There is no way to generate them with the MySQL windows install, so I am wondering if anyone has any exported copy of the latest tables.(sorry, this should probably have been in the Install Forum)
View Replies !
Creating Tables On Laptop Windows XP Home
I am an undergraduate student, and just installed MySQL 5.0 on my laptop running Windows XP Home. Now I am new to MySQL, and I need it for a class project for J2EE... Now can anyone please let me know that what needs to be done after I have extracted the MySQL files on C:, what is the next step I need to do, so that I can start creating tables
View Replies !
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?
View Replies !
Change Database Directory On Windows
I tried to move the default data dir to my data drive, because this is different from the system and program drive.But it seems that on Windows there is no possiblity to change this. Every time I try it the mysqld-nt service does not start.I can not belive such behavior! I it really true that on Windows you can't change the database location?
View Replies !
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.
View Replies !
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.
View Replies !
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?
View Replies !
|
TRACKER
