Backing Up A Table ... But Being Able To Access The Backup
I am making a database that has ordering information on it. When someone places in order it gets approved or not. When a order is placed, I want to backup the data(where it still can be accessed) and the orgainl database cleared so more orders can be placed(new ones)That way the old orders and the new orders do not get mixed up. So what I want to do is back up the orginal database and still beable to access it. Does anyone know if that is possble?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Can I Backup A Table By Backing Up Files In MyISAM Db Type ?
I want to backup a MyISAM table. Mysqldump command helps you to backup a single table by putting SQL commands into a file. However, suppose I backup 3 files of that table (.frm, .MYI .MYD) and restore them at any later point of time, will it work ?
How To Backup Database Data Without Direct Server Access
I need to backup a MySQL database (MySQL 4.0). But it is on a shared-hosting web server and so I don't have direct server access. I also have no phpMyAdmin installed. How can I backup the database? I think it is possible with PHP (version 5.0.2 is installed on the web server) to create a file with SQL commands which restore the data, but what is the easiest way to do it?
Backup Table
I'm using MySQL Administrator version 1.1.3 The data in the table contains some german special characters like ä, ü etc., but when I backup the table this special characters are seted to other ascii characters like ö to ö, ü to ü and so on. What should I do and which option I have to set, so that I get the same charset?
Backup [partial Table]
I have a table and i want backup just some data (example, query result for a ID_client=1). Is that possible?
Table Backup Query
What's the most efficient way (by using MySQL queries) to backup a database table? I had been doing something like this, in which I had to back up to two different tables: CREATE TABLE backup_1 LIKE main_table; CREATE TABLE backup_2 LIKE main_table; INSERT INTO backup_1 SELECT * FROM main_table; INSERT INTO backup_2 SELECT * FROM main_table; This process can be very slow. Is there a better way I can do this?
Live Backup Of Large Table On Production Server
I have a production server serving ads on our website using Openads (currently version 2.0) via PHP, MySQL, and Apache. It's been operational for over a year now and the database, two tables in particular, have grown to a few hundred megs. It's live and we can't afford any downtime for this server as it serves our ads to generate revenue for us. Whenever an ad is viewed, a new recorded is added to the database. However, in order to do a backup, usually mysqldump, that requires locking the table for several minutes, during which time, it locks the tables, and any httpd (in our case all of them) processes depending on those tables. Finally, the point of this post, DOES ANYONE KNOW A WAY OF BACKING UP OR DOING A MYSQLDUMP WITHOUT LOCKING THE TABLES for a very large database? Can I just run a query that will get me all the information without locking the tables (relational problems shouldn't be a problem yet cause its usually only 1 table being written to).
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!
Backing Up
I am running off of a MySQL database on a remote server. I am truly concerned about backup. I have phpMyAdmin running on the remote server, and I see I can "Export" to various formatsd from there, but nothing to "Import if I need to reinstate my data. How do you typically backup a MySQL database? Cant I simply copy the files? How does one do this if I want, say, to backup the files from the remote server, to my local harddrive?
Backing Up
I am running off of a MySQL database on a remote server. I am truly concerned about backup. I have phpMyAdmin running on the remote server, and I see I can "Export" to various formatsd from there, but nothing to "Import if I need to reinstate my data. How do you typically backup a MySQL database? Cant I simply copy the files? How does one do this if I want, say, to backup the files from the remote server, to my local harddrive?
Backing Up A Database?
Just to see if it would work, I exported my database using phpmyadmin (as a SQL file), then I dropped the database. I also use a ulility (MYSQLautobackup) to do the same thing, only it emails me a gzip file. Now, when I try to import the emailed file, I get this? (screenshot #1) But if I import the .sql file instead I get this (screenshot #2) and everything works.
Backing Up A Database
I want to back up a database that I have on my university computing account. Problem is they don't have phpmyadmin. I do have ssh access though.
Backing Up Just Portions Of DB
I have a DB of NFL players and stats. What I want to do is a sql 'backup' of just parts of 3 tables i.e. create a new DB for each team. I have tables for nflteams, players and player stats for all the NFL. I want to create a DB for say just the Rams. Any ideas?
Backing Up DB With Mysqldump
I just finished a big project which included a mysql database. I want to keep a backup of the database. Right not, the database is at school and I need to transfer it to my home computer. I've tryed using mysqldump command but I keep getting a syntax error. Both computers are using Windows XP. Do i need to download any special software in order to do it or can it be done in the mysql CLI. Also, I have no username or password to log into my database. Can someone help me out with the mysqldump command?
Backing Up Mysql
Is there a way to run a mysql dump from within another application? I would like to place a button in my application that runs the backup. Any advice?
Backing Up, And Restoring
OI've got a database and I'm using an MS Access front end and it works great. Trouble is...before I roll it out to users, I need confidence that I can back it up, and restore it if needed. So I tried deleting my database and restoring a backup .sql file using MySQL Admin. I get "MySQL error: 1064 There is a syntax error in your SQL statement..." and I can't read the entire message because the dialogue box cuts it off. (must be a bug) The thing is, the .sql file was created by the backup feature in MySQL Admin.
Backing Up Of Mysql
I'm trying to set up a system so that it backs up my MySQL Database every 2-3 nights (maybe everynight - not sure yet). I was wondering, what's the best way to backup everything in 1 database?
Backing Up On Windows
How do I back up files on Windows? I know how to do it on the *NIX platform. Whenever I run mysqldump, it doesn't export them in sql files to a place that I designate. It goes somewhere else, and I have no clue where that is.
Backing Up MySQL
I'm getting ready to backup all my MySQL databases. I currently have about 15. I have read here on devshed to use this command line (Windows)Code: c:mysqlinmysqldump --opt -uroot -p test > databasename.sql However since I am doing multiple databases should I do something more like (adding the -A)Code: c:mysqlinmysqldump --opt -uroot -p -A And do I just leave off everything past the -A? I'm suspecting it will use the database names assigned if I am reading it correctly.
Backing Up A Database
I have been using phpMyAdmin and have been very happy wih it. My website is hosted by a very capable/helpful person and that is good too. However, I have been having problems transfering large amounts of data. For instance to export a table with student information, names, courses, addresses, schedules etc., is impossible because the request times out. I don't have access to telnet. How should I handle such exports/imports?
Backing Up Stored Procs
I have noticed with MySQL Administrator when I backup stored procs they never restore properley.
Backing Up MySQL Database
I have an application using MySQL running on Windows Server 2000. If I were using Microsoft SQL Server 2000, I would need special software to back up an open SQL Server database. Does this same problem exist with My SQL? In otherwords, could I take the native NTbackup.exe that comes with Server 2000 and back up an open MySQL database without stopping the engine first?
Backing Up A MySql Database
I've taken a look at mysqlhotcopy and mysqldump but neither seem to do what I need them to do which is to backup only the data which has changed since the last backup. Is there a way to do this? Of course, being able to recover the database from these delta backups is important.
Backing Up Longblog Images
I use PHPMyAdmin. Whenever I wanted to backup my databases I would go to export and dump a .sql file containing all the data then copy and paste the file in sql window and evey thing was ok. This time the database includes a longblob field which contains image. Apparently the old solution wouldnt work anymore. I wonder now how I can backup and resore my database. Perhaps I should say that the data base is on a hosting and not my own computer.
Backing Up MySQL Database
I have an application using MySQL running on Windows Server 2000. If I were using Microsoft SQL Server 2000, I would need special software to back up an open SQL Server database. Does this same problem exist with My SQL? In otherwords, could I take the native NTbackup.exe that comes with Server 2000 and back up an open MySQL database without stopping the engine first?
Backing Up/exporting In MYSQL
I use MySQL to store my data in one table (approx 7 million rows) and use MSAccess as a front end. I need to export the data out to a file to pass on to some else. I have tried using the Dump procedue without success, although MySQL message informs me that the database has successfully dumped. The *.sql file is created but the data is missing. I have tried exporting to a *.txt file but the message I recieve is "Query doesn't return fields". I think my ODBC connection is OK because i can view the records through Access, however if i try to export the data to a *.txt file from within Access I get an 'ODBC call failed" message.
Backing Up Mysql Database
How can I use phpMyAdmin to backup both my database structure and the data within each table. My database has 4 tables. I need to move the database to another server and i do not know much about MySQL commands.
Backing Up A Non-local Database
I've just started working with MySQL, and have gone from developing php applications on my own computer to putting them out on the Web. I used to have a small batch program that would run on my machine that would do a backup of my Timesheet database. The syntax was simply: mysqldump --user=dave --opt --result_file="time_backup.sql" timesheet When I moved the application over to our company's Web server, I still wanted to do an automatic backup daily, and I put this into a batch file: mysqldump --user=dave --host=annexweb.kwic.com -p******* --opt --result_file="time_servback.sql" timesheet But when I run it to test it out, I get this error message: #1045 - Access denied for user: 'dave@adsl-216-94-26-35.kwic.com' (Using password: YES) I know I have the username and password right (I use them to log on through PHPMyAdmin). Can anyone point the way to figuring this one out?
Backing Up Users Permissions
I was wondering how I can backup user rights to a database that I have. I am able to create a dump of the database but how can I backup the user rights.
Backing Up Mysql Databases
I need to only give a few tables from my mysql database to someone else. How do I do this so that they can load them into mysql on their machine? I dont want to give them the whole database.
Backing Up Very Active MySQL Database
I'd like to know how some of you with very active MySQL databases (like large vBulletin forums) handle backups? mysqldump raises the server load significantly and slows the site. I think I may lose queries here if they back up while it's trying to do the backup. mysqlhotcopy complained about not being able to open some of the table files. I think it's running into locked files despite its attempts to lock them for itself as there are many queries per second on almost all tables. This is a dual-core Opteron 280 server with 2GB RAM. The database is about 2GB in size right now, and all tables are MyISAM type. Are there any settings I should tweak to get mysqldump or mysqlhotcopy to do the backup without effecting live services, even if the backup takes slightly longer to run?
Problems Backing Up AUTO_INCREMENT Tables
I've just realised that my 'fantastic' website has a really big problem. Because I can only use my online MySQL database via PHP and not a direct connection, I'm having to backup and restore using SQL. I'm backing up the tables by cycling through each row in a table and then creating a SQL script which contain an 'INSERT INTO' line for each data row (one script for each table). If a table needs restoring, the plan was to just truncate the problem table and run the SQL script and the rows get inserted back into the truncated table. Simple! Or so I thought. The BIG problem is that, if any rows have been deleted from the table before it's backed up, when the rows are inserted back into the table from the re-population script, the AUTO_INCREMENT command creates a nice new set of consecutive IDs. So the rows will get DIFFERENT primary IDs from the point of the first deleted row onwards!!! This is of course a huge problem, as the AUTO_INCREMENT column is my primary ID and keyed to other table records, so the records all point to the wrong records after a restore!!! I can't believe I'm the only person to have this problem. Is it possible to explicitly specify a value for an AUTO_INCREMENT column on insert, or temporarily turn off AUTO_INCREMENT before insert and re-enable it again after the restore, so my ID numbers stay with the records they were backed-up with?
Can't Access Table
I ran a php script to delete about 4 million rows from a table with about 10 million rows. Waited for a while (20 minutes?) and it seemed to be stuck so I killed the script. Now I can't access the table (although I can access others in the database). What can I do to unlock or free up the table again? Would restarting mysql do it? Is there a way to do it without restarting mysql? mysql version: 3.23.58
Cant Access Table
i have managed to set up a login system using mysql with no trouble. now i want to insert data from the mySQL table to a webpage, i have made the following PHP code (passwords and so on ive left out :) but there right): <?php mysql_connect("host", "user", "pass")or die("cannot connect"); echo "Connected to MySQL<br /><hr />"; mysql_select_db("members") or die (mysql_error()); echo "Connected to Database<br /><hr />"; ?> i tested the first part and it connects to the database, however when i connect to the table it comes up with: Access denied for user 'user'@'%' to database 'members' i dont know whats wrong? the only thing ive seen is in my mySQL database it says No Privileges on the main screen could this be it? its a college created account so they could be blocking me.
Testing The Database? Backing Up, General Checks
I want to know what else I can be doing to check the stability of our database. Currently what I do every evening is download the complete database through PHPMyAdmin on our dedicated server, once downloaded I start up the Wamp Server and import the database locally through PHPMyAdmin on my own machine. The next thing I do is run the Check Tables command on all the tables to see if everything is where it is. It always comes back as OK on each table so I presume everything is ok? Is there anything else I should be doing, or is what I am doing correct? Every so often we delete auctions to free up space in the database. Once this is done we have overhead in the tables. Sometimes this can be 2-10mb, so what I do then is run the optimise command on the tables, again am I correct in doing this? Finally our database is now over 40mb, to me this massive as the largest database I have worked on before has been 4mb, please dont laugh. What sort of database sizes have you seen in MySql or are you running at present? What is MySql like in the long run stability wise. If looked after can we get many years of good service from it.
Importing Table From Access
I've got a problem when I try and import a table into a MySQl database using MyPHP Admin and the Import CSV using LOAD DATA option. For some reason only the last record gets imported, although there are almost 700 records in the table. I regular import data into two other tables using the same method without problems, so I'm pretty sure I've got all the right parameters set up when exporting the original MS Access table as a CSV .txt file.
Transfer Access Table
I am working on a client's site that is on a server hosted in Germany. Communicating with the hosting company is not possible, but I have been given access to phpMyAdmin and can access the database for the client. I have an Access database that has one table in particular with Data that I would like to transfer over to the mySQL database. Is this possible? I am now downloading a program that will convert the databases, but what about getting table a from DB A to DB B?
Access Denied On Individual Table
Trying to insert records into 2 tables of the same DB, using Coldfusion query. It works on the first table, but on the second table I get 'access denied', although I'm providing the same username/password. When removing the username/password from the query for the second table, it works! I'm confused, because the table should have inherited the DB privileges (no table privileges set).
OLE Object From MS Access To A MySQL Table
I don't know which forum (MySQL or MS Access) that can help me, so I decided to put my thread on both. Sorry for the inconvenience. I want to copy a table from MS Access to a MySQL table. 1. The problem is, one of the fields in the Access table has data type of OLE Object. What would be the equivalent of OLE Object data type in MySQL? 2. Quite often that I lost connection to mySQL Server when I'm trying to acess tables in my MS Access that are connected (through) ODBC) to MySQL (Error #2013). Is there a way to fix this?
Error Accessing MS Access Table
In order to perform a hetrogeneous join (I think that's what they're called) between MySQL and another database, I've created an Access database containing linked tables from each datasource. I create the linked tables without any problems, clicking on "save password" before selecting the desired tables. I can then access both tables fine from within the Access GUI. The problem starts when I then try to access this data from my ASP.NET web application - classic ASP works fine but .NET gives me... ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'MyDSN' failed. From then on, the Access database remains locked (.LDB file in the same directory) and I get a similar error when I run my ASP page, which previously worked.
Trouble With Export Of Access Table Into Mysql
I exported some tables out of access into mysql and I cant edit and records under mysql root account through mysql's query browser. I can edit from mysql command line using same credentials while working localy on the mysql server. Wondering why Query broswers Edit button is greyed out.
Configure 2 Sites To Access One User Table
I have two databases on the same server with different domains. I would like both sites to access the same user database table. They have the same fields. I thought that it might just be done with an mysql command, which will point one table to the other.
Upload .mdb Access Data Into MySQL Table
I'm new to mySQL, but used to SQL Server.....which I'd be using DTS for this whole process. I'm glad to have to learn to do it with mySQL though. I have an Access .mdb file, that I need to upload from my local machine to our hosted mySQL site via BlueHost. I'll be using phpMyAdmin. It looks like the only way is to import into an existing table is from a text file. Are there any other ways to take the .mdb file and copy it up, and into the mySQL table? I got a converter tool, Access2MySQLPro 5, which has 10 trial conversions. Didn't know if anyone else has better ideas? Basically, I want to take this .mdb file data and put it on the mySQL table.
Slow Table Access On Local Machine
I'm running MySQL 4.1.7-nt on my laptop, and I'm accessing it through ODBC (MyODBC-3.51.10-x86-win-32bit). I'm developing a .NET web application, but I don't think that's relevant. I already had the application running OK on my desktop, and when I created the same environment on the laptop, retrieving trivial amounts of data (5 rows) from a table is taking 6 seconds. Updates the same. IN otherwords any table access takes 5 or six seconds. (Table only has about twenty rows in it). I can connect to the database on the laptop from the desktop (i.e - application runs on desktop, retrieves data from laptop - works fine, not noticeably slower than local on desktop. If I connect the other way - application on laptop, database on desktop, it runs just as slowly as locally. The effect is the same whether I connect to 127.0.0.1 or via the machine name. Code:
Access > Odbc > Mysql | Locked Table?
i have a mysql db and an odbc connection setup to it under user root. i need the odbc connection so i can have connectivity in access 2000. select queries work fine. i can view the tables in access etc. however update queries won't work for me. i know last week it worked, and this evening after it not working i opened up another copy of the database and it worked on that one... but only once, i went back and it didn't work in that one either. and for the life of me i cannot figure out what would be different with the database now. the error i'm getting is just the generic: "can not update 3 records due to lock violations" however, what is locking odbc/access out of the mysql db? is it mysql? is it odbc? or is access locking the records? im sure it isn't mysql, and i think it is odbc but i don't know where. i downloded new drivers for odbc. i thought about updating the access jet engine but couldn't find updates... Code:
Error Accessing MS Access Table Linked To MySQL
I create the linked tables without any problems, clicking on "save password" before selecting the desired tables. I can then access both tables fine from within the Access GUI. The problem starts when I then try to access this data from my ASP.NET web application - classic ASP works fine but .NET gives me... ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'MyDSN' failed. From then on, the Access database remains locked (.LDB file in the same directory) and I get a similar error when I run my ASP page, which previously worked. Code:
|
TRACKER
