Ubuntu :: Downgrade Mysql From 5.1 - 5.0 Without Loss Data?
Jan 7, 2010
i have installed ubuntu server 64bit with lamp so all in one (apache, mysql and php) and i need to downgrade mysql because of serious problems with mysql 5.1 and this is the only solution. But i need to be working with apatche and php also and have my.ini like i have now (can backup it) so is there any save way to do that?
I installed Ubuntu 10.04 on the laptop and it looks pretty good. I currently run 9.10 on the main desktop and would like to upgrade to 10.04, by pressing "upgrade" in the update manager, but I have some questions before I do, namely about data loss.
If I upgrade, will stuff like Thunderbird keep my emails, FF keep its profile (cookies, bookmarks, addons etc..), the documents keep all the documents, I have an apache server installed with a few websites - will they still be there after an upgrade? I also have a virtual machine with windoze on, what about all the stuff in there and VMware itself?
Or, will I need to back everything up onto an external hard drive (not sure how to backup Thunderbird and FF), and then reinstall everything, and transfer all the documents, websites etc.. back over again??
I have a 1TB External HD that at the time of purchasing was used with my PS3 which only allowed FAT32 HDs. But now I am using it for other uses. I have came across the problem of the file size limit of 4gb that FAT32 has.The problem is I have about 200 GB filled of data on this HDD and wish to convert it to NTFS with no data being lossed. Is this possible and if so how?
This forum might not be the best place for this question, but some people here are pretty knowledgeable and may have more insight than I do about this. Anyways, I'm thinking about expanding an NTFS (Windows 7) partition on my desktop computer into unallocated space. I know that there is a risk when shrinking a NTFS partition due to fragmentation but are there any risks of data loss from expanding a NTFS partition? My common sense tells me there isn't a risk but I want to be 100% sure I won't lose any files.
I have a Dell workstation, 2 HDD, HDD 1 setuped Red Hat 5.3 with LVM, and that HDD 2 is empty, not install RAID 1. And, I want to setup RAID 1 (hardware RAID)...but, have a problem. I don't want to lost data on HDD 1 when I setup raid, I try ghost or backup it, but when I restore, it error because LVM is setup on that.
I have a laptop running slackware-current. The disk is /dev/sda and the root 'sda1' is xfs formatted (there is also linux swap at sda2).
recently I was trying to setup openvpn and had to copy a folder with configuration files from /usr/doc/openvpn_<version>/easy-rsa to /etc/openvpn.
I am sure the copying completed cause I got a prompt, but a few seconds later the battery died on me. When I got mains and powered it up, I could see the directory I copied under /etc/openvpn, and the files where all there too. but they all contained nothing. i.e. they had a size of 0.
I read [URL] Fthat an external journal filesystem for root is not supported. I am not sure If it applies to my situation though. As in does it use an internal journal instead?
and the bottom line is: shouldn't the copying have completed successfully? shouldn't I be worried, that this copy failed?
This problem is not exclusive to Ubuntu, I've experienced it in Windows and OSX as well, but it seems that almost every time I transfer a large number of files (i.e. my music collection) between my desktop computer and laptop via my external hard drive, I end up losing files for no reason. I usually don't notice the files are missing until later on, because I am never informed of any data loss. Now, every time I make a large transfer of files, I just do it two or three times to ensure that I don't lose any files.
In the process of preupgrading to FC12. Towards the end of the process I get a warning that my /boot partition isn't big enough (12 recommends minimum of 300Mb).
Is there a tool I can use to resize my existing partitions WITHOUT data loss? I've been using gparted up to now for sorting partition stuff, does that maintain data when resizing (assuming I run from a boot CD or USB rather than a running system)?
I have 2 external drives that I'm using for movies and they're both formatted to fat32. The problem I'm experiencing now is that some of the high quality mkv files are not able to be moved to the drive because of fat32's limitations.
I'd like to convert to ext3 (or 4) and I wanted to check to see if I can do it without having to reformat and without loss of data.
Last time I installed Ubuntu in a dualboot configuration with Win7 on one of my machines, my entire boot sector and Windows install got corrupted, resulting in a complete loss of all my data and requiring a fresh install of Windows.
I looked into this a bit after the fact, and it seemed to me it was due to conflicting hard disk geometry between Linux and Windows.
My question is, how likely is this to happen with Fedora? Is this because of Ubuntu? A bad install? Is there someway I can avoid this from happening when I install Fedora if it will happen?
What are the advantages of the multiple partition setups other than resistance to data loss in crashes? Is there any other reason to have a special partition just for your boot directory (kernel files and config) than surviving a major crash?
Also, is it possible to make the Debian installer accept an existing set of partitions? Or even alter the size of the automatically created partitions? Does expert mode let you control the partitions? How many other very detailed things would I have to know to use expert mode, though?
We have made a fresh installation on DL 580 G 5 Server. The installation Completes successfully. When we reboot the server we find an error message " Logical Drive Disable due to Possible Data Loss. and then non system disk or disk error.
Due to this we have lost all of the data. We can successfully install Windows Server 2008 or 2003 or Redhat Enterprise Linux 5 on this server with no error no issue.we can successfully install Windows Server 2008, 2003 or RedHat Enterprise on RAID 5 or RAID 6 Or RAID 1 or RAID 1+0. we dont face any issue on these windows or linux platforms.We are only facing RAID Controller Issue on CentOS 5
There is a disk 500 gb, it is broken on /boot and on /root and on /dev/sda1 and /dev/sda2. Whether prompt it is possible to redistribute a disk without loss of data namely it is necessary to make/boot and two equivalent on disk volume.
Ubuntu 10.04. I've tried every method I can find and none work. Here's what I know...
1. My /etc/my.cnf is ignored. I can even delete it and phpmyadmin continues to work as it did before.
2. If I move /var/lib/mysql and replace it with a new directory (chowned to mysql:mysql so it looks like it's got the same ownership & permissions as the original) I get a write permission problem, e.g.
Quote:
What I ultimately want to do is used existing database files on a FAT32 partition but I can't even get to first base.
I have tried a few packages but cannot find an easy intuitive interface for editing tables in a mySQL database. I just need to simply edit the table field data, import and export multiple rows, and filter the table data so only the rows are returned based on a string that I search for. The tables I edit have several thousand rows and some up to 30,000. I do not know how to write queries and it seems all these packages require that you know how to write sql queries to do what I need to do. On the mac I used Sequel Pro, which is dead easy to use and is mostly point and click to do all the above. Since my mySQL experience is very limited, I really need something simple like this.
I have tried:
MySQL Workbench Navicat (lite version) MySQL Query Browser
how to do what I need to do with the above packages.
I already have my laptop as a server using a LAMP server + proftpd and the FTP->MySQL link up. I built myself a new Headless and set up the SSH and VNC on it and all that good jazz. LAMP works and everything. Proftpd+MySQL (using the proftpd-mod-mysql package from repo) doesn't seem to work on this headless box. So I used the tutorial from [URL]... Thinking "I'm using 10.04 - it's close enough". Both came up with the same error. 421 Service not available when I ftp from the localhost. Is their something I'm missing? the Laptop set up (also 10.04) works groovy fine. Also all the log files are blank.
I have just upgraded my old CentOS system,but something goes wrong(1) I can not enter database to MySQL from web page,and I had a "add new contact info" available there before .(2) I want to install SugarCRM to my web page,but SugarCRM can't create database with the right username and password . Other thing is OK, I can get data from MySQL from web page. Here is the package I have : php-5.1.6-3.el4s1.10 mysql-5.0.82sp1-1.el4_8
Does it because that these two packages don't match each other?
When a user logs into my webmail application, it creates entries in a table on MySQL called "identities" which works great however once the user is deleted fro Linux with the "userdel -r" command, the data still sits in MySQL. My question is how I can I remove the table data from old users? It appears as show below:
I use dual boot with windos 7. i use xampp in win7. want to use lampp for ubuntu 10.04. i want to use one local server directoy for both . i successfuly changed htdocs location in lampp. but could not change mysql data directory location.
I have about 200k data entries in xml file. I wrote php script (using php-xml) to read xml file and insert into mysql. At first it went really quickly inserting, then after a while after inserting 100k entries, it slowed right down, just like it would not even doing anything. I have CentOs with 512M on VirtualBox running as server.
I reinstalled ubuntu linux and lost some mySQL database files that were located in the /var/lib/mysql/ folder. I need to recover them ASAP. How do i go about it. Is it possible to recover .frm, .myb files using scalpel. Is there an alternate software I could use?
I have try to sync my MySQL Server database and HLDS Data on lan,one is windows server 2008 and one is Ubuntu Linux 9.10 i have try to use the remote address(192.168.0.4:3306) but can't connect and say the error code is 10060 i have check the connect is normal and ok,the accont is can let any address to contro.
My computer has broken and I cannot login. I don't know what caused it.
I am using Fedora 14 and so it is easy to retrieve my files with the Fedora 14 installation disk under the 'restore' option. I cannot however, work out how to retrieve my MySQL data.
Would anyone be able to shed some light on this matter?