Can I Access Databases By Placing Outside Data Folder?
Can i access MySQL databases if I save them in my own locations? Means, not in c/program files/MySQL/data but in d:/ or E:/ drives?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Copying Data Folder
I've successfully copy out a database folder under mysql/data directory and put it in another server and it works fine. No need to know the previous admin password or what for the copied database.My question is. Is this normal with mysql? Or this is normal with all DMBS, which we can copy the data folder from one server and put it in another servery, bypassing all the user security, and successfully read the database with admin privilaged given by the second server?Or this is only happened with mysql, and not with other DBMS such as ms-sql and oracle.Is there anyway to prevent this from happening?
View Replies !
View Related
Data Folder Structure
I am doing a data migration from access to MySql. I will like to know if I can create various master folders inside the data folder, where each of these folders will hold various databases inside the data folder. For example: One folder call Clients, that will hold databases for each of my clients.
View Replies !
View Related
Mysqldump Or Data Folder
I am trying to get a backup strategy in place for my customer. Here is what the software developer said about their software that uses MySQL 4.xx running on Windows Server 2000. Is this true? I do not see how this is possible. What we have learned with MySQL is you do not need to run a special backup to backup MySQL databases. The contents of c:mysqldata (or if the MySQL engine is physically located in another location, the data folder within that MySQL folder) can be backed up at any times, as the files open and close per request. If you have a scheduled tape backup, include this folder in the backup. If needed to recall this information, all we need are the entire contents of this folder, and you are back up and running, instantly.
View Replies !
View Related
Restoring A Database From The Data Folder
I was running a Windows Server 2003 machine and had a Hard Drive go out on me. I was able to save all the data on the drive in it's raw format, but had never made any backups (I know, dumb). I took the opportunity to install Mandriva 2006 instead of going back to windows. I now have a MySQL 4.1.12 server running and Would like to restore my data from what I saved in the data folder. So my question is this. Is it possible to restore the data that was saved in the windows data directory into the new database running on the linux machine? And if it is, how would I go about doing that?
View Replies !
View Related
Load Data From Mapped Folder
I have a mapped drive "O" on the PC running MySql. I want to use 'load infile' Tried the following: load data infile local 'O:/abc/boxes.txt' into table `boxes`; I've also tried : load data infile 'O:/abc/boxes.txt' into table `boxes`; I always get "Error 1064". If I change the path to the local drive, it works fine. Having the text files locally is not an option. Any suggestions?
View Replies !
View Related
Moving The Mysql Data Folder
We have a system that has been running for about one year. The thing is that the mysql data folder is on the c: partition and the diskspace is low, I wan't to move the data folder to the d: partition where it's lots of free diskspace. So my question is can i stop the mysql server copy the datafolder to the d: partition and edit my.ini regarding the path for the datafolder and start up the mysql server again without bumping in to problems??? Or is there any other suggestions on how to solve this? I'm going to move the folders on 2 servers (master-- slave mysql servers)
View Replies !
View Related
Accessing Remote Data Folder
I have MySql 4.0.17 server on my machine. My data folder is on a network drive. Recently I installed MySql 4.0.17 on a different machine, changed the my.ini file to point to the same remote data folder and restarted the MySql. I get the following error- "Could not start the MySql Server on local computer. Error 1067: The process terminated unexpectedly". So I copied the remote data folder onto my local machine and changed the my.ini accordingly, it is working perfectly fine. The storage engine is Innodb. Am I missing something here. I am pasting the contents of my my.ini file below. Code:
View Replies !
View Related
DATA Folder On External Drive
I have one question: my DATA folder has been moved to an external drive, simple plug & play for Windows XP. At night I simply turn off the drive and that's it. If I need it, I power it back on. Last night to test, I shut the drive off, then powered it back up. MySQL couldn't find my schemas. Reboot and everything is fine. I plan on testing this for a while just to be safe. Anyone see any long-term problems with MySQL and the drive suddenly being un-available ? Any suggestions ? (like shutting down via admin prior to power-off).
View Replies !
View Related
Where Are Located The Data Files, In Which Windows Folder?
I have imported a text file (11Go) in DBName.Table1 and i would like to know where are the data files on a WXP system. I know where is the DBName directory but there is only a Table1.frm (2ko) file. I use the innodb engine. ibdata1 (1.4Go) The record has 17 fields: 13 int + 1 tinyint + 2 Varchar(15) + 1 Datetime, either at less 70 bytes/record x 100Million records, either at less 7Go.
View Replies !
View Related
How Do I Reclaim Disk Space In Data Folder
I have 5 databases: - mysql - test - product1 - product2 - product3 The hard disk on my server was near full, so I decided to delete databases product2 and product3 as I no longer need them. I dropped the databases product2 and I noticed the disk space was not freeed by MySQL after dropping this database. The tables in databases product2 and product3 are INNODB. What is the best method to reclaim my disk space when dropping entire databases?
View Replies !
View Related
Copy/Paste DB Folder From Mysql/data
I swear once upon a time I was able to simply copy my DB folder from mysql/data folder and paste into new install (wamp) and so I tried just that today thinking all would be right. I dumped the wamp stack, and reinstalled, pasted the db folder back into the new mysql/data folder, and while phpMyAdmin shows the db in the list (with the correct number of tables) I get an error that that the first table does not exist! BIG BUMMER!!!:eek: How might I retrieve the data from this folder or otherwise resolve the error?
View Replies !
View Related
[MP2] Placing Apache
Will placing Apache::RequestRec & Apache::RequestIO & APR::Table in startup.pl to load them up for multiple handlers have any bad side effects? I noticed that when I load them via startup.pl the handlers that use them don't complain that they don't have the use statements within the module code and still work as normal.
View Replies !
View Related
Placing A Db Into Another Mysql On The Net
I have had a major stoppage of mysql on my mac locally, so i need to transfer my data to my online web space,i have the db file, how would i go about this if possible. if not how can i get the table etc contents from this folder if i cannot access it via mysql, saves me looking up everything and trying find out what was in my db etc and that.
View Replies !
View Related
Get Data From Data Folder
My server recently broke and I had to reformat it. Being the stupid noob I am I only had a backup of the servers files and not the sql tables. I have all the original mysql files and I was wondering if there was a way of getting the data on to a new sql server.
View Replies !
View Related
Access To Databases
i am setting up a web server, and want to allow the webserver to access only databases with a web_ prefix in the name, such as the database: web_test for security reasons. How can i do this as i have set up in the mysql.db table for the user webserver to have select, update, insert and delete privs on dbs web_% and when i try to "use" the test database, it is access denied
View Replies !
View Related
MS Access And MySQL Databases
I have an Access database that is used for a station computer. Now I want to update this database for a small network for about 4 computers (to share this database). I know that I can link an Access databse to a MySQL server. My question is: It is possible to use one of those for computers as a MySQL server then 4 computers will use 4 copies of this Access application to connect to the MySQL server to share data.
View Replies !
View Related
Access To All Databases For All Users
I have just started using MySQL and I am a little confused. Is there a way to let User2 have access and edit all databases created by User1? I have a database created by User1 called myDatabase and I want to have User2 access it as well as make additions or modifications to it, i am sure there must be a way but I dont know how to phrase this to look it up on the net.
View Replies !
View Related
Cannot Access My Databases In Webmin
I had a look in webmin and for some reason mysql had stopped, so I thought, right, just start it, so I tried to enter the mysql server admin area and got this... Webmin needs to know your MySQL administration login and password in order to manage your database. Please enter your administration username (usually root) and password below. Also this error at the bottom.... The full MySQL error message was : connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' It will not accept the admin name password etc even if I go into the module config and change the admin name and password? I started mysql with the start command in a shell as root but I still cannot access my databases in webmin I just get the above.
View Replies !
View Related
Restricting Access To Databases
I have phpMyAdmin installed on my server and a client of mine wants to be able to edit his website's database to make minor changes. Is it possible to give him a unique user name and password so that he only has access to his database and none of the other ones on my server?
View Replies !
View Related
Can't Access Databases Anymore (error 1044)
I am very new to MySQL, but so far things have been working beautifully. I think I got too smart for myself though. Using MySQL Administrator (on Mac OSX platform) I decided to change the username from "root" to "administrator", and apply a password. This seemed like a safe thing to do. However, now when I log in with this password, I can no longer create any new databases. I can access the ones I have created so far, but that's all.
View Replies !
View Related
LOAD DATA INFILE To Import Data Exported From A MS Access Xp
I am trying to use LOAD DATA INFILE to import data exported from a MS Access Xp table. But all i get in the date field is 00:00:00, as Access exports DATE and TIME and MySQL seems to use just the TIME portion of this. Is there any way to ahve MySQL import just the DATE portion or is there any way to have Access export only the DATE portion?
View Replies !
View Related
Data From 2 Databases
I have two databases... dg_reviews and dg_articles.... currently i am pulling three random entries out of dg_articles.reviews and displaying them... problem is that i now want to filter the randomness down to being genre specific, problem is the genres are stored in dg_reviews.reviews. The main similarity between the two databases is that they have the same exact ID entries for each entry. Is there a way i can match these and filter by genre?
View Replies !
View Related
Pulling Data From Two Different Databases
I need to pull data from two different databases in order to return some results for a web page I am working on. How can I do this using the same sql connection? Here's what my select statement looks like (pseudocode): SELECT * FROM db1.table1, db2.table1 WHERE db1.table1.UserID == db2.table1.UserID Here is my code to connect to the database; string SQLQuery = "SELECT * FROM users"; OdbcConnection ODBCConnection = new OdbcConnection(connectionString); try { ODBCConnection.Open(); OdbcDataAdapter ODBCAdapter = new OdbcDataAdapter(SQLQuery, ODBCConnection); DataTable dataTable = new DataTable(); ODBCAdapter.Fill(dataTable); }
View Replies !
View Related
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 !
View Related
Moving Table Data Between Databases
I've recently got a 2 new domains and with that 2 new databases. The name of one of the new databases is different from the database on my old host and I have 2 sites incorporated into that old database. What I'd like to do is split the old database into 2 newly named databases seperating the tables so I end up with the 2 databases ready for the new sites. The old site doesn't have phpmyadmin installed which is what I'm used to using and this DBTools software doesn't appear to allow me to select the tables I want to dump and export to a new .sql file in multiples.
View Replies !
View Related
How Can I Protect Databases Externally In The Data Directory
My question is how can i protct databases in the data directory externally? Anyone can copy data from the data directory in mysql server and paste it to another system where another mysql server with same version is loaded. If network security is tightened, still this problem will be there. Because hard disk can be removed and data can be stolen very easily in that case. So is there any solution for this?
View Replies !
View Related
Database Design: How Best To Manage Data Across Multiple Schemas / Databases
Our organization is looking for the best design for managing shared data. Specifically we wish to have a master table for data related to a Person. That person table would be shared by any other databases within the company that needed it. Of course, we do not want to share the whole master table, just the rows relevant to specific application that will be using it. We also want the sharing to be as transparent as possible to both the users and the support / development staff. Using a view seems like the way to go, BUT...each application has tables with FKs to the Person table. We can't do FKs to a view. We can have the application reference the view for selects / updates to the Person table, and have the other tables define their FKs to the master Person table, but we're a little worried about security since we can't narrow their permissions to only certain columns & rows like in the view. Oh, I am not doing a good job of explaining this.
View Replies !
View Related
Import Access Data
I have a database that contains information on items for sale, prices, etc. Every few months or so, I need to import data from an access database, to do the following: - insert any new items from the access database into the mysql database - update any of the current items with new information (such as price) I've done a good bit of searching on this, but most of the answers here revolve around a one-time import...this is something that needs to happen regularly.
View Replies !
View Related
Access To Data Bases
I downloaded the "Windows" version and installed it on my PC. I signed in as "root" using the following command on the shell: mysql --user=root mysql I added a new user named "admin" with the followin command: GRANT ALL PRIVILEGES ON *.* TO 'admin' IDENTIFIED BY 'pass.word' WITH GRANT OPTION First, when I try to acces mysql with the following command: mysql --user=admin -p and then typing the password when I'm asked, the access is denied and I get the following message: ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES) I need to enter mysql WITHOUT the password option. I expected to "create" new databases using that user, but whenever I try to do so, I keep on getting the following error message: ERROR 1044: Access denied for user: '@localhost' to database 'pelos' Isn't supposed to create a DB when I have assigned ALL PRIVILEGES to user admin? Why is it not accepting my password?? Sorry if the questions are stupid for most of you, MySQL connaisseurs.
View Replies !
View Related
MS Access Data Into MySQL Db
I have one table from an MS Access database full of records that I want to import into a mySQL db. Is there an easy FREE way to do this? I downloaded a DB Converter MS Access Conversion Wizard tool and that created a file with my table and records from my Access DB. The file it created was an .sql file. Now how do I import those records into my mySQL database?
View Replies !
View Related
Using MS Access To Get Data In / Out Of A MySQL Database
I have no experience using MS Access to interface with MySQL. I have a tiny MySQL database that might need to have Access connect with it over the internet and grab data/update etc. Is this practical and what does it take to do it? My project is not time sensitive but I'd like to see what methods I can use to do remote queries with my database running on a *nix/Linux server.
View Replies !
View Related
Access To Mysql (import Data)
I have been using MS Access for some time and want to convert/move to mysql I should like to import the tables rather than re entering all the data can anyone point me in the right direction or where I can find a good intro to MYSQL?
View Replies !
View Related
Access Intranet Data Base
I have a db in my intranet, and I need to access the information from my web site which is hosted somewhere else (internet). Whats the best way to do this? Should I use a public IP for my intranet server? (then theres no point on hosting my web site some where else right?Could I syncronize both MySQL data bases?
View Replies !
View Related
Access To Deleted Data On Desktop PC
I'm involved in a court case with someone regarding a website using the Xoops CMS. They want details of news items submitted to the site but subsequently edited by myself. I've stated that the original submission has been overwritten and now no longer exists in any form. They claim that it might be 'cached' on my desktop PC, but I've explained it doesn't work like that and that the information they seek has gone forever. (I think they are getting confused with IE cached files.)
View Replies !
View Related
Importing Data From MSSQL And Access 97
I have a need to run a daily data gathering to pull information from three separate applications into a single MySQL database for reporting purposes. We are currently doing individual reports using iReport which works well, but I want to automate things - here's what I need to do: Import data from remote MS-SQL databases Import data from local or remote Access 97 databases Ideally, I want this to be a batch process running as one or more cron jons on a linux server (PHP or or PERL scripts?) rather than a GUI-driven exercise. I am looking at the various bridges from Easysoft but wondered whether there is a better place to start?
View Replies !
View Related
Updating Data Into Mysql Using MS Access
I am finding loading and updating data into mysql extremely cumbersome. I have set up MS Access to work as a front end and can export and import data to/from mysql table. The easiest way is to load all the data in an MS Access table and export it to mysql. So far no problems. However, when I import this table back into MS Access, edit it with new data and then try to export it back into the same table in mysql it won't allow me to do this telling me that the already table exists. I can get round this by changing the name of the table in MS Access (say from 'Table' to 'Table1') and exporting this. But I suspect I will have to modify any PHP scripts I may have in the future to reflect this change.
View Replies !
View Related
Limiting Users' Access To Only Their Data
I'm working on a single database with a dozen or so tables and fifty or so users. Essentially every record has a field defining the user who generated the data; think scientists' measurements. Up until now we have not been concerned with restricting access to the data. Now we would like to implement some security in the sense that a particular user would only be able to interact with his or her data; that is I would like to restrict a user's privileges based on the value of a particular field for all of the records in a given table. Is this possible? One idea I had was to generate a database for each user with only his/her data, and grant the user privileges to only this database. This seems a bit clumsy though. Other than that, I can imagine implementing something through the front end when the data is selected, but this seems problematic because if someone knew SQL and their username and password they would be able to access everyone else's data with another frontend.
View Replies !
View Related
SQL Database In Any Folder
I have been using Access for my website databases and I want to use MySQL now. With Access I can put the MDB file anywhere, in any folder of my site and just have Coldfusion MX link to it. Can I do the same thing with MySQL database files? Do they HAVE TO STAY in any particular folder or can they sit in any folder? Exmp: wwwroot/site/database/db.opt OR db.MYI
View Replies !
View Related
Folder On The Server
what folder a usual mySQL is in on a server that uses apache based Cpanel? I have root access to my server and need to adjust a mySQL file according to some info I found in mySQL.com but I canīt find that file nor the folder for mySQL on my server, so I wonder wether anyone of you could give me some "usual" folder where mySQL could be in.
View Replies !
View Related
Extracted Folder
I recently had problem with my installed MySQL (5.0.24a Standard) on my Mac PowerBook G4 (Tiger 10.4.9 uk). MySQL doens't launch anymore. To be sure to not lose my main database ('imagebank'). I copy the entire folder of 'imagebank' on my desktop. After tried lot of tricks (to try to launch again MySQL), I decide to reinstall the 5.0.41 packages. Now MySQL launch again, but How can I import the folder of my 'imagebank' database? Because I tried to placed back the entire folder (by drag'n'drop') but can't reach the infos (via phpMyAdmin 2.10).
View Replies !
View Related
How To Run MySQL From Another Folder?
trying to build an application with Ruby on Rails (I'm learning) and I'm following the tutorial but it's not very well explained. It's like I have to write a MySQL command into another folder (my application folder) and it doesn't work. Here's what the tutorial is asking: " After I make sure I'm in the cookbook2 directory, I enter: mysql cookbook2_development <dbcreate.sql " But of course, it doesn't work because "mysql" command only works when I'm in the MySQL folder! Everything else seems fine (the file create.sql exists, the cookbook2_development database is created, etc).
View Replies !
View Related
|
TRACKER
