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 Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Import A Directory Of Text Files Into A Mysql Database With Php?
I have a directory of text files that i'd like to import into a msql table... I was wondering if there's an easier way to do this with php/mysql, I'd like to avoid copy/pasting the entire directory (thousands of files) into the database if i can. The directory structure of the text files resembles... somepath/A/Aerosmith/Song Name.txt - (extention varies) What i'd like to do is use php to scan the directory and input the file path information and the content from each file into a table like... Dir Artist Song Text Type ------------------------------------------------------------------------ A Aerosmith Song Name Fa La La La La (example text) File Ext B Beatles Song Name Fa La La La La (example text) File Ext
Import A Text Backup Of SQL Db Into Another One On Linux
I have a SQL file, which is a backup of a database (data+scheme). The file was generated using MySQLGUI backup features on a windows 2k3 server. Now I would like to import this data + scheme into a mysql server running on linux, there is no GUI on the machine. 2 questions if I may: 1. How do I import the described above data. 2. Will the meta data (permissions, collation & co.) will be restored as well, or will I need to reconfigure them ?
Change Database Directory
I have a linux server and i installed mysql . it's working fine. But i want to change the mysql database dirctory from /var/lib/mysql to /db/ how can i do that.
Change Database Directory
I have a linux server and i installed mysql . it's working fine. But i want to change the mysql database dirctory from /var/lib/mysql to /db/ how can i do that
Dropped A Database, But It's Still Showing Up In The Directory
I dropped a database used for practice. Although all the tables are gone, the empty database itself is still there. Is this correct? How do I get use of this empty db? Note: I'm using Mysql version 3.23.49 -nt and I also use mysqlfront although I generally use the command line to work with the dbs.
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.
Cannot Start Database After Relocating The Data Directory
an error after I have relocated my data directory.I found the pid error-log file "bsd19.err" in the previous data directory and it wrote the following every time when I tried to start my database. [Error]/usr/local/libexec/mysqld: Can't create/write to file: /usr/local/db2 (Errcode: 21) [Error]Can't start server: can't create PID file: Is a Directory I also have "chown" the user as mysql on that directory /usr/local/db2 before I start my database.
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?
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?
Mysql Database Backup
i need to backup my MYSQL DB i found the following at http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html but i dont realy understand it. Example: mysqldump --add-drop-table -u dbuser -pPW DBNAME > /tmp/examp-back.sql 1. what is "--add-drop-table"? what does it do? do i need it? 2. is it possible to just stop the DB and then copy the MYSQL DB folder? and how is the restore if i just copy? 3.is there a switch to backup all DB's? like "--alldatabases"?
Backup MYSQL Database Remotely
I have a couple of MySQL Databases that store forum data on a number of servers.....and recently had an issue where the serve crashed and i lost a load of data...i want to prevent this from happening in the future and limit the amount of data lost....... is there a way to backup or mirror the data in my mysql dtabases to a copy which i plan to store locally on my PC, purely for backup purposes?
Take Backup Of Mysql Database Using Mysqldump
This is my first post to this forum. I'm using MySql 4.1 with .Net 2.0. I've to provide facility to the administrator of my application to take backup of mysql database. Database is on different machine. I'm dynamically creating bat file to run command. Here is my bat file:- SET mysqldir=C:Program FilesMySQLMySQL Server 5.0in SET mysqlpassword=root SET mysqluser=root @REM Change to mysqldir CD %mysqldir% ECHO 'WAIT .......' ECHO 'GENERATING TSIPOS DATABASE BACKUP FILES ......' mysqldump -h -u root -proot tsi_db_dbo > C: sidbodbbackup_Test.sql TASK:- I have to take backup of database running on diffrent machine. and to save the script on yet another machine. You can see three machines are involved:- 1) Where Application is running 2) Where Database exists 3) Where to save backup script.
Cron Job Backup Of MySQL Database
I would like to backup a mysql database to a text file using a cron job and then have the file mailed to an email address. Can anyone point me in the right direction on doing this type of thing? I dont have much expericnce with CRON.
Using MySQL For Website Database Backup / Restor
so apparently MySQL is widely used for web site backup's of databases.....however i cant seem to figure out how that is supposed to work. i am using joomla, and i have a couple ways of makeing .sql backups, but im not sure how i am to put the database on again, or if need be, on a second website. am i making sence? i need a way to "import" my database to a website incase it gets 'nuked' or something. is MySQL the right program for this, or not?
Backup Database Like Mysql Administrator Using Mysqldump
when i backup database using Mysql Administrator,it generate insert clause every 9 records.when i use backup sql file to restore, the speed is very high. but if i use Mysqldump, it generate only one insert clause with all record.and its restore will cost a very long time.
MySQL Administrator Backup Directly To Local Database
In MySQL administrator is there a way to backup directly to my local database from a remote host. I would ideally have this done automatically once a day. I like to test locally and don't want to have to restore the database locally each time a backing from the remote site is done.
Backup/Restore Mysql Database From Remote Server To Local Pc
Im trying to download mysql database "dbproducts1" which is residing in my webhost's server (Linux). From telnet i backed up using "mysqldump -u -p dbproducts1 > dbproducts1.sql" Then i downloaded this file via ftp to my local pc(WinXP). Now on my local pc to restore database i went to command prompt and i did following: mysql -u -p dbproducts1 < dbproducts1.sql I got following error: ERROR 1064 (42000) at line 380: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-workshop ( title varchar(250) NOT NULL default '', decription longtext NOT ' at line 1 I opened the phpmyadmin and found that dbproducts1 database was restored but with only few tables i.e. not all tables in the db was restored. Can somebody please help me to backup/restore this database. I checked the mysql server version and found following: server version: 5.0.24a-community in my local winxp pc server version: 3.23.36 in my webhost's server (Linux)
What Front End For Office Database / Web System
I would like to replace our current MS Access database with a linux based system. Our needs are as follows : A database to store our pertinent data A means of accessing the data from within our office (forms, reports, etc) A method for our clients to access our data from their offices ( ex..a web based access to our database) I am currently in the research phase, soon to be followed by the "learn a new language(s) phase." So I am a blank slate at this time, any recommendation is possible. How would you recommend I proceed? What structure, what languages, etc.. I have started reading about PHP with MySQL, would that fit the bill?
Online Education System Database
Requirements: -> Admin will log in and create student login and assign them course like MBA, MS. ( one student one course ) -> Student will login using his/her login(roll#) and password. -> I want that a student who belongs to MBA could access to only MBA course materials like (books or chapters)
Backup MySQL Via Port 3306 (which Tool? Automatic Backup?)
i have quite a big database on my website - and i cannot get any backup via system dump or scripts anymore, because my hoster added some memory limits - and scripts/dump can't finish... so the only way left is to backup my database via connection to port 3306 and tools like mysqlfront. mysqlfront is unfortunately quite slow and buggy - so do you know any tools which can backup databases via external connection? - it would be great if there are tools which run automatically? (batch/commandline??) backup with mysql.exe - h -u .... is impossible, too!
Friends/buddy System Database Structure
I'm about to integrate a friends system into my website and I was wondering what the best schema would be for this kind of thing. The friends system will be an invite only system, so a user must send an invite to the user he wishes to add to his friends list before that friend can be added. The invites will be stored in an invites table, but I was wondering on how best to record the friendship between two users (once an invite is accepted). I was going to follow vbulletin's schema of which stores this information in a single field, in the members table. This field consists of the user id of each friend, seperated by a space. My second option is to set up a seperate table which stores every single friendship. Although this would be easier to manage/handle (since each friendship has to be mutual), I'm a bit worried about the excessive amount of records this would create. Would anyone know what the best approach would be? I'd be very grateful for your input.
Transfering Database From Local System To Live Server
I have a site running locally on my notebook and I copied my site to a live server. I have no problem getting the PHP & HTML files to the server, but i'm not sure how I can move the database and data to the live server. Can I copy a file to the live server like I can with an MS ACCESS database? Or do I need to recreate the whole database on the live server and somehow figure out how to transfer the data?
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.
MySQL Or Directory Tree?
I'm working on a project where I have about 5 different data structures (objects) consisting of about 15-30 fields each. The size of each object is about 2-4 kB. The maximum number of objects will be in the range 5000-100000 for each object. I need possibility to search, add, delete, update and get these objects by ID, NAME, DATE and VERSION only. I have no need for the individual fields of the objects only complete objects as binary files. When I work with the objects I need access to roughly 5-10% of the objects at a time. Right now I have all these files in a directory tree under Windows XP with ID, NAME, DATE and VERSION included in the file name. I can do all I need but it becomes too slow sometimes. Now to my question: Can I benefit something from moving to a MySQL database when it comes to performance and speed and how should I set up the datbase to make it as fast as possible?
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.
Accessing Mysql/bin Directory Problem
This may be very basic question, that I hope some of you can answer very quickly for me. I'm running mysql 4.1 on windows xp just to learn the database, and I'm in a need to run .exe in the bin directory. The problem I'm having is accessing this directory. The path is C:/Program Files/Mysql/Mysql server 4.1/bin but when I get to C:/cd "Program Files/..." I get an error message saying (parameter format not correct - "program) i have tried several things, as well as following a user guide for changing directories that states that if the folder name has spaces use " to access that subfolder...maybe there is a simple tip ...
Change MySQl Data Directory
I moved the data dirctory to a network drive.... this is why it's not working Is there a way to house the data directory off a networked drive/share?
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.
Database Backup
Well i don't really know if this should be posted here, as i use mysql along with php but i believe it is more relevant to mysql forums. Is there any way of automatically backing up a db, say once a week? Kind of a programmed process lets say..
How To Backup Database?
I have mysql and a single database. I'm moving from one host to another. I was instructed to "backup database from old host and restore in new"
Database Backup
I have MySQL (4.0.13) installed on a Windows 2000 Server, interacting happily with ColdFusion MX. However, my hard disk system has collapsed, and I need to back up all data before a virgin OS is installed. My question: how do I back up a database, and reinstall it, using MySQL?
Database Backup
How do I synchronize MySQL table data of my home PC with latest data from a remote server ? My home PC is on a very slow internet connection, so implementing replication will cause long time read lock on remote server, which is not desirable. What are the tools for manual sync of tables ?
Database Backup
I have a backup of a mysql database that i made using cpanel, then i changed hosts and now im using ensim. How can i restore this backup now?
Database Backup
I have MySQL (4.0.13) installed on a Windows 2000 Server, interacting happily with ColdFusion MX. However, my hard disk system has collapsed, and I need to back up all data before a virgin OS is installed. My question: how do I back up a database, and reinstall it, using MySQL?
Backup Database
I would transfer a domain from an hoster to another, and I'dlike to transfer databases, also. I encountered someproblems with phpMyAdmin, and I thought: IT IS POSSIBLE TO CONNECT TO A SERVER AND BACKUP A DATABASE WITH MYSQL ADMINISTRATOR, or another MySql tool? How to configure the connection?
Backup Database
I Have been using mysql for a while. I downloaded this from mysql site and I created/edit whatever only on the command prompt. My question is, since my database is huge now. I want to copy that database into somewhere else that is safe cause I am going to upgrade my codes, just to prevent if something goes wrong then i can get back my tables and datas. How can I do that?
Database Backup
when i use mysqldump command for taking backup of my database from shell , it works , command is mysqldump databasename > path to store But i want to take backup of my database at "mysql" prompt. As my hosting company , logs me in direct to mysql prompt VIA putty. I have no access to shell. I also donot want to use phpmyadmin or other GUI softwares.
Database Backup
I've been trying to call mysqldump.exe from Visual Basic with no success, so this time I will try to do it via SQL commands.
How Do I Set Up A Regular Backup Of My Database?
I know I can do it manually in phpMyAdmin, but is there a way to set up a scheduled back-up say once a day? It would be even better if I could set up some sort of cycle where at any one time I'd have 7 versions backed up (Monday-Sunday) and each day that backup would overwrite its old version (that is, on Monday the db backup would be saved over the old Monday backup, and on Tuesday it would be saved over the Tuesday backup). Just in case something goes unnoticed for a couple days I would have the ability to jump back to a given day within a week.
Partial Database Backup
I am developing a hosting solution for a popular open source script: on the website users can sign up to get their own "virtual" copy of the script. There is a single database, but own tables for each user. Database tables engine is currently MyISAM, but I am going to change it to InnoDB. What I need is to let each user download a backup of own data, and restore it when s/he wants. The users shouldn't be able to change other users' tables structure/contents. Also, the backup should be encrypted, so they can't simply check out its contents. One of the possible solutions is to tar the tables files, encrypt the archive, and that would be the backup. But in case user decrypts the archive, s/he would be able to change table structure and other details, making the system function improperly. Of course, as encryption algorithm strength grows, it becomes harder to encrypt the archive and make the system work incorrectly and/or change other users' info. Should I just use some strong encryption algorithm and tar the table files? Does InnoDB allow to work with table files of an open database? Or should I lock the required tables for that?
Backup Large Database
I have a database which is around 6gb. May I know which is the better way to backup my database? 1. Copy the MySQL data directory to create a backup or 2. mysqldump? I'm just worried that zipping up the data directory will make the MySQL hang as I'm goin to zip a big directory. But using mysqldump, will it consume many server resources?
|
TRACKER
