Ubuntu :: Cannot Move Mysql Data Directory
Nov 6, 2010
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.
View 2 Replies
ADVERTISEMENT
Jul 20, 2011
I am running ubuntu 11.04 I'd like to encrypt my home folder. - how can it be done, without creating new user/starting from scratch. -I'd like to keep all the files and desktop settings - the only change should be that the folder is encrypted now.
View 2 Replies
View Related
Aug 31, 2010
We have a test server in which we have not taken backup. Contents under /etc is entirely lost.
I need to execute scp to copy mysql data directory.
Also it is in remote location. Can I recover the data by scp by creating some /etc/passwd , /etc/shadow files ?
View 6 Replies
View Related
Aug 23, 2011
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.
View 4 Replies
View Related
Aug 1, 2010
I came from the Debian world so I did not do much building software from source. I successfully built wine from source, now the wine binary is in the same directory where the Makefile and all of the other source stuff is. I can run wine from that directory fine, but I sort of want to move it somewhere else. I tried moving the wine binary somewhere else, but when I try to run it I get
[code]...
What all do I have to move into the new directory to get wine working in the new directory? By convention, where should I move wine, I want it available for all users, should I move it to /opt/wine, or /usr/local/wine, or somewhere else?
View 6 Replies
View Related
Jun 3, 2010
Ubuntu 9.10 64bit. Acer Laptop
Using ubuntu 9.10 cd to access laptops hard drive.
foun readme file in /media/disk/mark
opened with openoffice. THIS DIRECTORY HAS BEEN UNMOUNTED TO PROTECT YOUR DATA.
From the graphical desktop, click on: "Access Your Private Data"
or
From the command line, run: $ ecryptfs-mount-private
So I tried a couple of ways...
View 9 Replies
View Related
May 9, 2010
I have some data files that should be distributed with my program. Using dist_pkgdata_DATA in Makefile.am, I get these files installed to /usr/local/data/share/package-name. The problem is that data is read-only, and my program needs to modify it. Playing with dist_sharedstate_DATA, dist_localstate_DATA, dist-data_DATA varibles, I got different installation directories, like /usr/local/com, usr/local/var, but data is always read-only.
How can I distribute modifiable data files with my package? I need some common directory for all users, or maybe local data in a user directory.
View 1 Replies
View Related
Aug 27, 2010
I want to move the location of MySql data file by setting datadir variable but I cannot find the variable in my.cnf file.
Should I set the variable in my.cnf, or is there any other configuration file beside this one?
View 2 Replies
View Related
Nov 8, 2009
I just installed mysql and need to move the databases to a new location.I say 'no problem' I shutdown mysql (service mysqld stop) I configure my.cnf to point to the new location, which in my case is: /mnt/data/mysql. I know not very original naming. I do the old chown -R mysql:mysql /mnt/datal/mysql AND I copy all the files over (cp -R /var/lib/mysql /mnt/cgsvol/mysql) chmod 777 /mnt/data/mysql I ensure the chown worked (ls -a -l) and the files are there from the old directory. I can't load the daemon again. I check the log (/var/log/mysqld.log) and it can't write any test file to that directory.
(log file exact data).
091107 23:22:21 mysqld started
091107 23:22:22 [Warning] option 'max_join_size': unsigned value 18446744073709$
091107 23:22:22 [Warning] option 'max_join_size': unsigned value 18446744073709$
[code]....
View 3 Replies
View Related
Jul 27, 2010
I would like to know if there's a way to copy my 500GB HDD data onto a 1TB HDD. Is there a quick way to do this?? Or will I have to install CENTOS on the 1TB HDD and then move the data across? Reason for doing this is because I am running out of disk space.
View 5 Replies
View Related
Mar 7, 2010
I have been trying to learn iSCSI from google but there is one main point that remains unclear. Is iSCSI suitable to move data between IP of [URL] and IP of [URL] rather than between 192.168.xxx.xxx and 192.168.xxx.xxy?
View 1 Replies
View Related
Jul 20, 2010
I'm trying to move a folder via sudo mv ioncube /usr/local/bin/
but it says something cannot move since directory is not empty. What do I do now?
View 5 Replies
View Related
May 17, 2011
I have a directory which was downloaded and has a silly name like "-=Directory=-" on my headless (no GUI) linux box and when I try to deal with this directory using "mv" in order to rename it or move it somewhere, it simply does not work. Terminal instead says:
Code:
mv: invalid option -- '='
how I can rename or move it?!
View 6 Replies
View Related
Jun 16, 2010
I have 2 hard disks, one is full and I would like to move my /usr directory from sda1 to sdb1.
I tried the following..
sudo mkdir /driveb
sudo mount /sdb1 /driveb
cd /driveb
sudo mkdir /usr
sudo cp -b --copy-contents -r /usr /driveb/usr
code....
I don't fully understand the difference between a directory and a mount point and I may be treating them wrong.
I would like /usr to point to sdb.
is it possible, or should I try to change my path instead and ignore this problem?
View 8 Replies
View Related
Jun 29, 2010
I would like to move the /home directory to a different location, there only seem to be guides on how to move it to it's own partition.
I have a drive (/dev/sda5) mounted as /media/data
I would like to move /home to /media/data/home?
I have tried usermod but get the following error:
Code:
test@TestServer:/media/data$ sudo mkdir /media/data/home
test@TestServer:/media/data$ ls
home lost+found
test@TestServer:/media/data$ sudo usermod -dm /media/data/home
usermod: user '/media/data/home' does not exist
View 2 Replies
View Related
Dec 28, 2010
Ubuntu 10.10 32 bit/ and /storage are on two different partitions. I want to move my home directory to the /storage partition, so I went to System -> Administration -> Users and Groups then Advanced Settings then the Advanced tab. I changed Home Directory from /home/billy to /storage/home/billy. I click on ok and I'm asked if I want to copy all the user's files over to the new location or start fresh. I click, Copy Files. It acts like it's doing something, but all it does is create the home/billy directories inside /storage, but it never copies files over and the next time I go to /home/billy it's still in the old location. What the heck is the deal?
View 7 Replies
View Related
Jun 22, 2011
How do you do this without breaking all the links and preferences in /home? Does the system take care of everything? Has anyone done it or is it actually system crippling?
View 2 Replies
View Related
Nov 25, 2010
i need your help for executing an script to copy data from upload folder to some other after successful upload. Do you have any idea for this?
View 1 Replies
View Related
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?
View 9 Replies
View Related
Mar 12, 2010
I'm doing a little work on my media center and the scrappers seem to do a much better job when each movie is in a directory with the name of the movie. However that's not how i have things set up.I have a few hundred avi files i need moved to directory named the same as the avi file.
View 3 Replies
View Related
May 7, 2011
We have two folders: source folder and destination folder. In source folder we have many sub folders and many files of different type!Script that would copy or move defined number of files from source to destination folder. Files must be selected randomly and sub folder in source folders must be selected randomly and we don't copy or move defined number of files just form one sub folder in source folder. In destination folder sub directory structure of source folder should not be preserved. Solution should be robust and as simple as possible.
View 9 Replies
View Related
Jan 10, 2011
I would like to know how to move all the files from a single folder and its subfolders to a single, different location in as few steps as possible. For example when I download files from one of my school's websites, the file I want is located in a deep sub-directory. So, I have to cd many times just to get to the file I want. Is there a way to recursively move all the files within a folder's subdirectories into a new location?
View 2 Replies
View Related
Jun 28, 2010
When installing Ubuntu (10.04) I chose the /home to be installed in a separate partition.I would now like to move the /srv directory into the same partition. The problem I found is that Ubuntu did not make a /home directory inside the partition itself. It just places the account directories in the partition and mounts it to /home. So I cannot just easily move the /srv folder into the partition.
How can I:
Move those account directories into a home folder inside the partition Make that new home folder the default /home folder. ditto with the /srv folder, or any I choose in the future.
View 3 Replies
View Related
Feb 2, 2010
I have a directory , there are many files created in it , I want to use the command to move the files which elder than 30 days and gzip it and then move it to /tmp , and then remove those files , I tried use below command but not work.
find ~path -type f -mtime 30 -exec tar -zcvf - {} --remove-files > /tmp/oldfile.tgz ;
View 1 Replies
View Related
Feb 18, 2010
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.
View 7 Replies
View Related
Aug 10, 2010
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.
View 2 Replies
View Related
Jan 19, 2010
As I regularly move between Mac and PC, I thought it would be a good idea to put all my data on an external drive. As Windows 7 and OS X have similar home folder layouts, I just simply put all the folders I need for both on the root of the external drive and changed a few settings so that the Home folder for my user is on the external drive on both Windows and OS X.
Whilst Ubuntu also has a similar structure, I cannot work out how to have it so that my users home folder is on the external drive. I have done a little research and all I can find is how to have the /home directory on another partition. a) this is not what I'm trying to do, just the folder for my user and b) this would mean formatting the external drive to extX format, which just wouldn't work for me.
I am using 9.10 (or will be once the upgrade is complete)
View 9 Replies
View Related
Mar 1, 2010
I've found several posts discussing how to do this in with the terminal, but none exactly fit what I am trying to do. And since I'm still very new, I was hoping for some help.
I have a parent directory called "Music." The subdirectories all start with "artist", some go further as in "artist/album/cd1". So right now the structure varies in the following ways code...
How can I move all the files (or the file types that I choose) to the parent directory "music"?
(By the way, for any who are interested, this is so that I can use an external hd with a PS3. ("playstation 3"--for anyone who was in my predicament searching the threads)
View 7 Replies
View Related
Apr 14, 2010
I'm running Ubuntu 9.10 and Gnome-Do 0.8.3.1. I have two issues I hope someone can help with.First I've managed to add two folders to the doc, however when I hover over the icon the name is displayed as "..." This might be because the path of the folder is "/home/eric/Desktop/500" which is a link to "/mnt/500" I cannot add the folder without the error listed below. When trying to add folders, and some applications I receive the error:
"Docky Error - Docky could not move the file to the requested Directory. check file name permissions and try again."
View 1 Replies
View Related
Nov 11, 2010
i want to move a directory to an external hard drive this is what i did
Code: konlah@konlah-laptop:~/Downloads$ sudo mv -i LinuxCBT /mnt/EXTERNAL after that i did
Code: konlah@konlah-laptop:~/Downloads$ ls so the file wasn't there anymore.. but i couldn't find it in my external hard drive.
View 1 Replies
View Related