Install To Find / Migrate Back Up Data
My server crashed and I backed up the DB files. I have reloaded MYSQL and it is running and copied the old db files back into a folder. how do I get MYSQL to see it as a database and work?
View Complete Forum Thread with Replies
Related Forum Messages:
How To Put Old Database Files Back Into A New Install
I've inherrited a product that is trying to use mysql. Noone seems to recall the root password. I tried all the published methods I could find (--skip-grant-tables and the other one where we set the password in the init files) and none of them work. So, I went to a second approach. I deleted my installation of mysql, reinstalled and reset the root password. Now, I can't figure out how to get the old data into the new installation. Copying the data files into the data directory doesnt work. I assume I need to do some sort of import? I need to import the data and schemas alike.
View Replies !
Migrate Data
how I can migrate data from Access to MySQL. I would appreciate very much is anyone can share his/her experiences with me.
View Replies !
How Often Is Best To Create New Database, Migrate Data With Shared Hosting?
I have got a web site that I have ben working on since March, 2007. It is a news reporting web site. It is replacing an older web site. I created a new database (it uses the MySQL database) last March when I started working on the new web site. I have migrated all of the news content from the old web site database to the new web site database. I have a shared web hosting. It's my understanding that the hosting service provider fills up one server with databases then starts a new server with databases. For example, the IP for the server that is hosting the current database for the new web site is 10.6.166.5 I just created a new database (the hosting allows you to have ten databases per shared hosting). The IP for the server for the recently created database for the new web site hosting is 10.6.166.92 If the servers are ordered sequentially there have been 87 new servers filled up with databases since last March (i.e. 10.6.166.92 recently created IP minus 10.6.166.5 March, 2007 IP equals 87 servers). The problem with migrating the nine-month old database to the new database is that I have got over a thousand news stories and two thousand pictures stored in the database with the 10.6.166.5 IP address. I would have to copy and paste all of the data into the phpMyAdmin program or write a PHP script that would automate the process. Is there any benefit to migrating the 10.6.166.5 March, 2007 IP database over to the more recently created 10.6.166.92 IP database? Would it be reasonable to expect the more recently created database to perform better over the next 12 to 18 months than the one created nine months ago?
View Replies !
Easiest Way To Back Up Data
My question is: How do you make back up or .sql files from tables which you have already created on MySQL? ====================================== Added info after reading the first 2 answers: Our old web server crashed and we retrieved the 3 files for each of the tables (.frm,.fyd,...) now after installing MySQL on my computer I have to find a way to get .sql or any other acceptable format for these tables and load them into the new web server's MySQL. The new host does not allow tranfer of these files hence I can only upload data in .sql or other similar formats. Since I can not use PhpMyAdmin on my computer.
View Replies !
Upgrade Mysql :: Get Back Old Data
I uninstalled older version of mysql 4.025 or some ancient thing. Now I didn't back up the database, but thought i could move the data folder over. Is there any way to get back into the old data? its the password access.
View Replies !
Find Data BETWEEN Dates
I got the following structure in my table : -------------------- userid | reg_date -------------------- 1 | 2008-10-21 2 | 2008-10-22 3 | 2008-10-23 4 | 2008-10-23 -------------------- I need to get the users registered between 2 dates. But my input will be only a day of the month, something like : 21. So need to find users registered between 21 and the current date.
View Replies !
Cannot Find /usr/local/mysql/data/
Everything was going great until i got to page 20 where it says to copy the my.cnf file into the folder /usr/local/mysql/data/ i'm wondering if Mac OSX 10.5 Leopard altered the location of this file or why I can't seem to find it.
View Replies !
Migrate DB From 5.0.51a To 5.1.30
It has a relatively large (17 table) database which is basically a custom made forum. It was made in MySQL 5.0.51a which at that time came as part of the WAMP5 server package for Windows. It has been about a year since I worked on it. Foolishly, I did not keep hold of the WAMP5 package that I used. I have downloaded the new WAMP5 package, which comes with MySQL 5.1.30. At first, the old database was not visible to the new MySQL server version. On the old backup I have, the data was located in C:wampinmysqlmysql5.0.51adataaaron_forum. I have basically moved the aaron_forum directory to the new MySQL data directory at C:wampinmysqlmysql5.1.30data and it is now picked up by the new MySQL server installation... however... it doesn't contain any tables according to my PHP, or indeed to the MySQL server. What is odd, is that it does actually display all 17 tables, but then when I try to open a table, it says that it doesn't exist. Quite interesting. I wanted to know if there is a way to migrate the data from the 5.0.51a generated MySQL server to the new 5.1.30 server?
View Replies !
Migrate From 3.23 To 4.1
I'm trying to migrate our mysql 3.23 database files to 4.1, is there a tutorial for this? Do I just copy the MYI MYD, and frm files from the 3.23 data directory to 4.1 directory?
View Replies !
Migrate 4.1 To 4.0- Possible?
I am running a big Drupal site on Host B, which uses MySql 4.1.19. Host B sucks and I want to move to Host A. Except they are running MySql 4.0.27 How can I get my database to work? I tried using dbase from Host B on Host A and am getting syntax errors, preventing the tables from loading. Quote: MySQL said: Documentation #1064 - 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 7
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 !
Migrate 5.0 Database
HI am working on a website with CMS and i am having few issues. I did my database for the CMS and i used the v5.0. from my computer. I did not know in first place that the company that hosts the website were using v3.23.55 on solaris 8 I cannot import the datadabe or create a database with collation utf8_unicode_ci. it gives me a syntax error.
View Replies !
Migrate The Records
in my records, there are some japanese characters and when i migrate the records to mysql, the data became some string like ???????? instead showing the japanese character correctly
View Replies !
Migrate Only Differing Rows?
Im currently using 'mysqldump' to dump the entire contents of my local database to my remote database. This was fine, but now the database is huge, so I would like to know if there is a MySQL command/statement that compares the two databases and then only uploads rows that have been updated on the local database. Is this possible to do? I can do this through PHP in a loop, but this takes ages, and I have a feeling there is a much more efficient way to do it using SQL statements.
View Replies !
Migrate Oracle To MySql
I am looking for the best solution for migrating Oracle DB to MySql DB that are both on UNIX Sun Solaris 9 boxes. I started out with Oracle Migration Workbench, MySql Query Browser, Administration kit, Oracle client and an intermediate PC. Haven't had any luck. I am getting plugin errors even though I can ping the source machine and put the plugins in the plugins directory. Has anyone done this before. And if so, where did get the info from or how did you do it?
View Replies !
Errors Get When Try To Migrate Form Mysql4 To Mysql5 Using Mysql Migration Tool
I am running mysql server 4.0. I have installed the mysql5.0 in the same server. When I try to migrate form mysql4 to mysql5 in the same server I get java heap space error. I was looking the google the change the java heap space. But did not get any thing. I am running with win2k and mysql4 and mysql5 with JVM installed with 512 MB Ram. There for I tried some other way. Even I installed my sql 5 in some other server in LAN whitch has more RAM and then try to migrate form mysql4 to mysql5 though the LAN I get some strange error saying Code:
View Replies !
Back Up
I am running php, mysql on window xp. When user insert something to the database (mysql). where does the information stored? I want to be able to make a back up copy of my data just in case I want to move from one pc to another.
View Replies !
What Back-end Database
I'm starting to learn Visual Basic. My aim is to develop a small downloadable application that can store and display contacts. It has to be small (say 2 mb footprint?). Q - First, will Visual Basic give me this small footprint ? Q - What back-end database is advisable (I'm familiar with MySQL), considering that the tables will be small ? Basic goal is that the application should be universally downloadable, installable (on all windows) and must fit in a small footprint. Q - Or let me ask very broadly - what technologies would *you* use if you had to develop such an application ?
View Replies !
Mysql Back-up
We have an online catalogue running off a mysql database, which we can back up. When we back it up, it creates a file online called "database.sql" which, when opened in Notepad starts... DROP TABLE IF EXISTS store_category; CREATE TABLE store_category ( category text NOT NULL,....etc
View Replies !
MySQL Back End
I have an Access application which uses an Access database. I want to replace the Access back end with a MySQL one. Can I link the new database? Can I do it in any other way? I reckon I should be able to, since MySQL has an ODBC driver but just not sure how
View Replies !
DB Back-up SSH || Forum
when i backed up dB using SSH db is for exmaple 50 MB Code: mysqldump -u zodehala -p123 db > backup/vb.sql but if i use vBulletin its interface to back up db is for example 80 MB What is the difference between them ? what is technical explain ?
View Replies !
Back To MySQL4
I have built a website using PHP5 and MySQL5 only to find that I cannot find a host that uses MySQL 5 yet… I have now changed the site to access the database via PDO. Problem is, PDO does not currently work with MySQL5 (correct? If anyone could tell me how to get PDO to work with MySQL5 this would be brilliant!) I therefore need to load MySQL4 onto a machine that is already running MySQL5. Do I need to uninstall MySQL5 first?
View Replies !
Getting MySQL Back
I am getting relay-bin logs on my master server. They are all empty except for one line that reads: þbin I have no slave settings in my my.cnf file. Any idea where these are coming from and how to turn them off?
View Replies !
How To Get ID Back After I Insert A New Row?
I have 2 tables , article and tags. article has 3 fields, id, title , content tags has 3, tagid, tagname, aritcle_id insert into article (title, content) values ('abc','abcd'); I need article ID back to insert tags into tags table. my solution is add new select statement before insert into article (title, content) values ('abc','abcd'); I can select max(id) from article, then use this id number to insert article and tags tables. not sure if this is only way to do it or there is a better solution. also, if there are alot users use my web application simultaneously, i am worry that user A issue select statment to get max ID, before he uses it. User B also select max id, then they probably get same ID number.
View Replies !
Back Up Database
I have MySQL 5.0.22 installed on Windows XP (32 bit) - on few machines. 1. To make a backup - do I have to run mysqldump or can I just copy C:Program FilesMySQLMySQL Server 5.0data somewhere? If so, how can I restore the database having data folder? 2. If I need to transfer the database from one machine to another (the same OS and MySQL) - can I use binary files from data folder or mysqldump is the only option?
View Replies !
Made A Back-Up Od DB
I made a backup of my database the other day, i have gone to upload it and i am now getting the following error. ERROR 1064 (42000) at line 6: 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 '"-- Generation Time: Jul 17, 2008 at 04:45 PM" "SET SQL_MODE=""NO_AUTO_VALUE_' at line 1
View Replies !
My Tables Back Into A Database
how I can get the backup ( just a file copy of the directory with .frm, .MYI and .MYD files) back into a newly created database. I am failry new to MySQL. Due to a crash of my Windows 2003 server I was in a hurry creating a very quick backup so I didn't tokk the time to find out what a correct backup mechanisme shoul be. Now I have a new server and installed the latest MYSQL (I think I had an earlier version before) I just copied the files into the "mysql datafiles" folder. It doesn't pick them up automaticaly. Can anybody tell me how to get them back in.
View Replies !
Getting Back Set Order From The IN Param
My query is as follows: SELECT STRINGTEXT, TOKENID FROM WEBSTRINGS WHERE TOKENID IN (6,20,234,19,32,4,800,177) All I want is my resultset to come back in the order that I have defined in the IN clause, but unfortunately SQL is trying to be too helpful and sorts the numbers in the IN clause so that the resultset comes back with a TOKENID order of 4,6,19,20,32,177,234,800. I don't want this bloody order I want 6,20,234,19,32,4,800,177!!
View Replies !
Mysql, Get Back Your Youth
<p> <div align="center"> <br> <a href="http://www.herbal-medical.biz/projectx/hgh.html"><img src="http://www.herbal-medical.biz/projectx/hgh.jpg" border="0"> </a><br> <br> <br> <br> <A HREF="http://www.herbal-medical.biz/projectx/hgh.html">Click Here If Image Doesnt Load</A> <br> <br> </div> <CENTER>WdXfuRttYR, yJJZQwQUqY <br> <br> <small><small><font face="Helvetica, Arial, sans-serif"><A HREF="http://www.herbal-medical.biz/optout.html">No Mo<!-- jptZc -->re Em<!-- CtuQR -->ails Pl<!-- QNVOU -->ease</A></font></small></small><br></CENTER> <p>
View Replies !
Roll Back Problems
I am rolling back a transaction that (up to the rollback command) has inserted into two tables, both of which are type InnoDB. I am getting the warning: "Warning: Some non-transactional changed tables couldn't be rolled back" I check the database and it seems to have rolled back all the changes I expected it to make, so why is this error occurring. I am using MySQL 4.0.18; is it a a minor known bug? Is there "hidden" tables that it is updating that might be causing this warning?
View Replies !
Back Up MySQL In A PHP File
I need a script that will find all tables and all rows and all data it makes a file called back.sql with all the info in it. How do you do that. My Web host dont got PHpmyadmin or nothing.
View Replies !
Getting Unicode Back From Database
I am converting data from widestring to utf8 strings to try to get it onto MySQL, using Delphi's UTF8Encode and UTF8Decode functions. But it's coming back as gibberish. I copied the word кодом from the russian page of the zeoslib site. Looking at the numeric values of the characters of that I got 043A, 043E, 0434, 043E, 043C, which corresponds with the Russian character chart on unicode.org. I converted that to utf8, which gave me: D0,BA,D0,BE,D0,B4,D0,BE,D0,BC, which is a simple conversion. That was then saved to the database. So far so good. But when I read that back, it came back as C3,3F,C2,BA,C3,3F,C2,BE,C3,3F,C2,B4,C3,3F,C2,BE,C3,3F,C2,BC, i.e. four groups of four bytes, where the last of each group correspond with the 2nd char of the utf8, but the other 3 are not useful. (3f = '?'). And when I pass that to UTF8Decode I get a blank widestring returned. So, I can't do much with it as is. Does anyone know what's going on? And more importantly, what is the right way to get unicode into and out of a database? I'm using MySQL 4.1.3b for Windows, with the latest zeos components.
View Replies !
Roll Back Using Bin Log On Myisam ?
Is it possible to roll back changes on MyISAM tables using the bin log? Some tables were dropped, truncated, or delete from'd (not sure yet), and need to know if there's anything we can do without an active backup.
View Replies !
Read Back Up File
I got this error. shell> mysql -e "source /var/lib/mysql/test.sql" backuptest ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'backuptest'
View Replies !
Auto Back Up Of MySQL
I want to Automaticly dackup my MySQL DB, and then upload it to a FTP site so I have a off site back up. Anyone know of any programs (open source is preffered) that would allow me to do this. I was think batch file my self in scedualed tasks but I am no too sure of what commands to use. This is on a windows 200 server too.
View Replies !
Reset Fields Back To 0
I've been running through some test where I have fields for a Win, Loss, and Tie. in a table. Now that testing is almost complete. Is there a way to reset all rows back to a 0 value?
View Replies !
Get Back Image File
I am sort of new to this and I have been searching for a few days now and can not find anything on this at all. What I need to be able to do is take a image stored in Mysql and save in back to the server as a file and I can not find out how. I know its got ot be simple and I am not the only one that needs to do this ... so can someone clue me in here.
View Replies !
Save Queries In Back End
Is it possible in MySQL to create and save queries in the back end DB. I am used to MS Access, in which you can put together a complex query and save it in the DB Backend. Then use the query in a ASP page instead of long SQL.
View Replies !
|
TRACKER
