Ubuntu :: Open Transferred Mysql Databases From An 8.04 Partition To A 10.04 Partition?
Sep 21, 2010
I transfered some mysql databases from an 8.04 partition to a 10.04 partition. They wouldn't open because the ownership & group was root:root since I transfered them as root. I looked at the original ownership of the files on 8.04 & found they were all "sane:124 ". I changed everything to mysql:mysql on the 10.04 partition & everything works O.K. now but I have no idea where that owner & group came from.
Two things I don't understand:
1 -Why I had to change ownership from root:root when I was logged in as root in mysql & the databases didn't show up?
2 - Where did the original "sane:124" ownership come from?
View 1 Replies
ADVERTISEMENT
Oct 5, 2010
all of the website content will be on a separate partition called "/websites". I've got SELinux enabled, and set the context on /websites and subdirectories to "public_content_t", so that httpd (Apache) can access this partition. This works. However we also have mysql databases stored on this partition as well, and we are getting errors like this in /var/log/auditd/audit.log: type=AVC msg=audit(1286249333.390:326): avc: denied { search } for pid=6167 comm="mysqld" name="/" dev=sda3 ino=2 scontext=system_u:system_r:mysqld_t:s0 tcontext=system_u:object_rublic_content_t:s0 tclass=dir
I've tried setting the context to "mysqld_db_t" on the MySQL database folders, but it appears that it cannot get to the partition at all, or anything outside of /var/lib/mysql/. How can we get mysqld to access databases on this partition? Right now there are symlinks from folders in /var/lib/mysql/ that go to each database on /websites partition. Setting SELinux to Permissive mode gets everything to work fine. Basically with SELinux in Enforcing mode, we're getting errors in the PHP applications that httpd can't connect to the databases.
View 4 Replies
View Related
Jun 18, 2010
I was having issues with MySQL Server and uninstalled it. I still have my databases at /lib/var/mysql.
My question: if I install MySQL Server (same version, 5.1) again, will it delete my databases, or will they still work?
View 1 Replies
View Related
Jan 20, 2010
I use a version of Ubuntu Desktop Edition 9.04 and installed various server software useful for my needs.
New issue. How do I get MySQL databases working on this system, and how do I get myPhpAdmin to help manipulate said databases onto the system?
View 7 Replies
View Related
May 27, 2011
I installed Debian stable and I see these errors in the xsession error file
/etc/gdm3/Xsession: Beginning session setup...
GNOMEKEYRINGCONTROL=/tmp/keyring-j0E6Br
SSHAUTHSOCK=/tmp/keyring-j0E6Br/ssh
GNOMEKEYRINGCONTROL=/tmp/keyring-j0E6Br
[code]....
View 4 Replies
View Related
Aug 12, 2010
Quick searches did not bring forth any standard solution.
I have installed Ubuntu Server 10 (x64) using LVM with two disks (this is a Virtual Machine on VMWare ESXi4)
During install I selected only disk 1, and LVM guided Installation Added LAMP and SSH
Server gives only a text mode configuration, great if you are a linux guru, but I am not so it took a bit to find a stripped down GUI. None could be found but I did the following:
apt-get install xorg gdm gnome-core (minimal Gnome install)
apt-get install gnome-system-tools (users and *****s, time)
apt-get install gnome-network-admin (network config)
apt-get install update-notifier (updates)
[Code].....
I have created a similar system with Ubuntu, now I wish to move the var/www directory to sda1, and the databases from MySQL.
View 8 Replies
View Related
Sep 18, 2010
Trying to set up a backup for mySQL databases in CRON.
I've entered the following line in /etc/crontab:
Code:
7 13 * * * root mysqldump -u root -pMYPASSWORD --all-databases | gzip > /home/myuser/mysql_backups/database_`date '+%Y-%m-%d'`.sql.gz
grep CRON /var/log/syslog shows:
[Code].....
If I run the command outside of CRON, it creates the backups no problem, but CRON is not doing anything.
View 3 Replies
View Related
Mar 8, 2011
I have a laptop and a desktop PC, both running Ubuntu 10.04 and both are configured the same way. I am using Unison-gtk to sync the data between both computers... This works for everything... except for my mysql databases. Any way to simply sync my mysql databases on both computers. Right now I need to do this table-per-table... and it is quite long to proceed like this. What I need is a script or a program (open and preferably free) that would just compare both databases (all the tables) and sync them either by updating existing tables or by creating them. This should work both ways... obviously. I could write a script for this, but I am sure there already is something for this out there.
View 9 Replies
View Related
Mar 25, 2010
I need to move mysql databases from my hard drive which is currently in external box. I can't boot the drive since the laptop is down. Nothing of the distribution on the drive is missing. I just need to know which files/folders copy to my new computer to have all databases running. Old computer ran on Dreamlinux (Debian-based). I'm currently running Ubuntu 9.10.
View 5 Replies
View Related
Mar 23, 2010
I have installed mysql ,php ,apache,phpmyadmin i have create a forum on mysite check it on[URL]..Now i have create a database with name login and then i create a table with name loginn ..After that in loginn table i create colums with name username (data type=varchar),and password(data type=int);i want when someone entered username and password in my sql ,it goes to database and userconnect to next page as we generally do in orkut or other social sites;I dont know how to connect with php with mysql and how to do it whole
View 3 Replies
View Related
Jun 8, 2010
How do I restore MySQL Databases from an old hdd with Ubuntu on it which won't boot? Information below is not necessary just explaining how I ended up in this situation. Today the harddrive crashed on one of my development servers and I have no recent backup of the MySQL databases on the server.
The stuff on the server weren't horrible important but it would still be nice if I were able to recover some of the files. This is the thing, I don't think the harddrive is entirely dead because it comes to a screen saying harddrive error something enter to continue then it says GRUB in the upper left corner before the computer crashes/reboots.
So I installed Ubuntu server on a new HDD and now I want to attempt to recover the databases from the old HDD by mounting it in Ubuntu but before trying I would like to know who one does that. As I've understood it's a bit more complicated then one might thing because MySQL uses binaries and not plain-files.
View 2 Replies
View Related
Mar 9, 2010
I have a system with opensuse 11.0 and mysql
After changing the administrator password only information_schema and test databases are shown in GUI tools (webmin or mysql administrator GUI tool). After the error I restored the password to the old used
if I use mysql in terminal, and use show databases; I can see the 7 databases that I have.
I aslo cannot access to any field using GUI tools (cannot acces to database permissions, or MySQL Server Configuration, host permissions or MySQL system variables). The error is:
DBI connect failed : Access denied for user ''@'localhost' to database 'mysql'
Do you know how to restore the view/access to databases?
View 1 Replies
View Related
Feb 15, 2011
Starting mysqld daemon with databases from /var/lib/mysqli m installed mysql-5.0.77-4.el5_5.4
[root@serv ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@serv ~]# /etc/init.d/mysqld stop
[code]....
View 6 Replies
View Related
Aug 2, 2011
Rebooted my server after some funky stuff started happening with mysql. Turns out the drive that stores the mysql databases has gone missing. I did an fdisk, and the partition table is gone. I used gpart to see if there were any partitions available & there were -- two + one swap. Can you help me put this back together I know very little about reconstructing a table to use... Here is the output of what I've talked about...
b14:~# fdisk -l
Disk /dev/sda: 164.6 GB, 164696555520 bytes
255 heads, 63 sectors/track, 20023 cylinders
[code]....
View 1 Replies
View Related
Aug 7, 2010
how can I display all databases and their size using command lines (linux) in a mysql server?
View 3 Replies
View Related
Sep 29, 2010
I know very little about MySQL, but I've got some users that need it for testing on a Linux server.So I had set it up a while back, but now I'm running into some small problems.Right now, each user has his own database that I created and can do whatever with it. Each user only sees their own database.I didn't want them to be able to create new databases at all, but they can and when they do anyone can see them.
EDIT(Apparently they can only create databases beginning with the word "test" in the name)
I need to either:
1) Stop them from creating new databases (without affecting their ability to interact with the existing database)
OR
2) Make it so that when they create a database, only they have privileges on it and only they can see it (except mysql root of course).
Anybody know the statement to set these kinds privileges up?
EDIT: pfft... I've a read a bit more and realize that this is an intended part of the installation.
EDIT2
I'd still like to remove the ability to make test databases.
EDIT3:Ok, for reference this is how you prevent users from making and using test databases:
shell> mysql -u root -p
Enter password: (enter root password here)
mysql> DELETE FROM mysql.db WHERE Db LIKE 'test%';
mysql> FLUSH PRIVILEGES;
View 4 Replies
View Related
Jun 10, 2011
Relational databases usually have their data over in /var/lib/something. Users are in /home (with data in /var/www). How can I apply a single total disk space quota across all of these independent software systems (file systems, RDBMS, etc.)?
P.S. There's a bet going on around me as to just how awesome SU is. Let's see what you've got.
View 1 Replies
View Related
Dec 17, 2010
how to configure a web/database server.
Given:
IBM x3650 M3 with 6 x 300GB SAS and 16GB RAM CentOS 5.5 (LAMP) Software RAID with LVM haven't tried hardware RAID.
Here's the task:
Task 1. 3x300GB SAS will goes to /boot, /root, /var* and swap (RAID1 for /boot and RAID5 for the rest with LVM). Task 2. 3x300GB SAS will goes to MySQL Database (RAID5 and LVM). * My web content will be stored here. (/var/www/html)
I know how to perform Task 1, but I'm not familiar with Task 2. So how it can be done? What specific directory should i used to store my database?
View 1 Replies
View Related
Mar 2, 2011
I am trying to use a command to open a partition or disc from the top like open up external drive, and not have to be externaldrive/videos or whatever. The reason being is to use in cairo dock, I have tried to drag n drop like i am able to with regular folders, but no good. I seen the option to run a command, and figured I would try it that way.
I have the partitions and discs i want to access mounted. they are:
External Drive (/dev/sdc1)
Storage (/dev/sdb1)
Windows (/dev/sda2)
I tried to open them in terminal, /media/storage: no such file or directory;
/dev/sdc1: Permission denied;
open /media/storage or /dev/sdc1
Couldn't get a file descriptor referring to the console;
se7en@PC:~$ nautilus /media/storage or nautilus /dev/sdc1 .....
Along with a pop-up saying 'the location is not a folder'.
View 1 Replies
View Related
Jun 23, 2011
So I just downloaded Ubuntu to be put on my other partition(I have a C: and a D: drive) So stupid me had a brain fart and ended up not making a new partition and putting Ubuntu on the D: drive which was 3/4 of my total hard drive. So now I have 120 GB for Windows and 350 GB for Ubuntu. So I went to Gparter on Ubuntu and tried to open it and it had an error before it even opened. And when I first went in to Ubuntu it had like 2 things pop up with errors. So I went back to Windows 7 and tried to use the partitioner there and it wouldn't let me expand my C: drive. What am I supposed to do?
View 4 Replies
View Related
Nov 18, 2010
I am having no luck configuring ProFTPd on a Debian Lenny production server we use to host our MySQL databases and a few websites. I had originally set it up so I could login and manage our internal sites, but I have the need to allow a few clients in to access their sites that we host. I am trying to root the users in their site directory, which would be "/sites/www.whatever.com/".
It just hit me while typing this. Is it possible to create a user without a shell to prevent login via SSH and set the home folder to /sites/whatever instead of /home/username? That would allow me to continue operating with my current configuration and root them in their site while preventing SSH logins.
View 6 Replies
View Related
Feb 12, 2011
I am a newbie to Linux. I am currently running Windows 7 and looking to have a dual boot system. I started by going through the Windows Control Panel to shrink the current partition. This left me with a 7.75 GB recovery partition, a 100 MB system partition, a 160 GB partition for Windows and 130 GB unallocated.
My question is (1) do I need to do anything with that 130 GB partition that is unallocated and (2) when I run the OpenSuse CD to install, how do I make sure it installs to that 130 GB partition?
View 2 Replies
View Related
Feb 20, 2011
Two days ago I repartitioned my laptop HD and added the latest Ubuntu (2.6.35-25-generic) to the existing Vista and existing Ubuntu (2.6.32-28-generic via upgrades from 9.14(?)). Prior to this install it was using Grub with menu.lst from the old/upgrade Ubuntu. After the install the boot menu labels the partition with Vista as the Windows Recovery partition and the recovery partition item is no longer present.
At first I wondered how I could get Vista to boot. I found that SuperGrub cd would boot it OK. Then, it dawned on me that the boot menu item was not the recovery partition, but instead the Vista OS partition mislabelled . Vista loads just fine from it. The recovery partition is no longer listed as it was with Grub/menu.lst. SuperGrub will not boot the recovery partition, showing an error "missing BOOTMGR".
'os-prober' produces--
root@Toshiba:/home/deh# os-prober
/dev/sda2:Windows Recovery Environment (loader):Windows:chain
/dev/sda7:Ubuntu 10.04.2 LTS (10.04):Ubuntu:linux
[code]...
I edited boot/grub/grub.cfg so the boot menu item is labelled correctly, but suspect that it will revert back when there is an upgrade.
View 4 Replies
View Related
Feb 23, 2011
I had a drive with a partition layout like so:
~50gig Windows 7 - NTFS
~100gig Ubuntu - EXT3
~100gig Snow Leopard - HFS+
~100gig Extended Partition
-- ~100gig Swap Disk - exFat
I wanted to delete the Snow Leopard partition and format the Swap Disk partition to something else. exFat was causing major file size bloat on small files. QT sdk bloated to like 11 gigs or something ridiculous like that. Anyways, I loaded up an Ubuntu 10.04 LTS live cd and gparted then deleted the Snow Leopard partition. Gparted said "Mission Accomplished" and tried to rescan the drive, but never found it. At this point I restarted the computer, a dell laptop, which didn't boot with an unable to find a bootable device error. The ubuntu live cd doesn't see the drive anymore. gparted scans for drives indefinitely and fdisk -l has no output.
View 9 Replies
View Related
May 29, 2011
I have around 30gb of free space in my partition table immediately before the Linux partition. I want to resize my linux partition to take up this space.
I tried booting with live cd, sucessfully umounted the hard drive but found I could not resize the partition. On clicking the 'edit size' button, partition manager recognised the free space before the partition but when i reduced this, the 'ok' button was greyed out. (it was not greyed out for the windows partition so I could, in theory, increase the windows partition to take up the free space but this is not what i wanted to do).
I am pretty sure that I had managed to unmount the drive correctly as the padlock symbol had dissapeared (I took the attached screenshot, which does show the lock symbol, after rebooting into my normal system).
Anyone got any ideas as to why it wont allow this? There is no reason why i can resize the partition to take up the free space BEFORE it is there?
View 9 Replies
View Related
Jul 18, 2011
I just installed ubuntu via the windows executable and I couldn't mount my NTFS partition. I found this a little odd and I checked fdisk and it seems to think I don't have an ext4 partition as my entire internal HD is displayed as NTFS.
Here's the fdisk output:
When i try to mount the NTFS partition /dev/sda2 i get the following output:
I can't make heads or tails out of this. Anyone know what's going on here?
Windows recognizes that 30GB were taken from the NTFS partition for my linux install. It reads the max partition size as 465GB. fstab reports the NTFS partition size as 488GB.
View 2 Replies
View Related
Sep 1, 2011
i have instaled ubuntu 11.04 wubi on my pc with windows 7. i installed and everything was going ok i navigate on ubuntu already. but the problems star here i went on my ubuntu to the partition section and i format my windows partion to be the home partion and changed the nfts to ext, i did the upgrades but i forgot that theyr running yet and i restart my computer when it boot again it gaves me an error:
try (0,0) : nfts5 : wubildr
try (0,1) : ext2 :
and the windows7 says that i have to instal again. so i went to another pc and i made a cd boot and a pen boot. i burned the iso (downloaded from the ubuntu oficial site the 11.04 32 bit version) image to the cd and pen drive prperly, i adjust my boot options to star from usb or cd rom and nothing im struck.
View 9 Replies
View Related
Sep 4, 2010
Trying to install Ubuntu (any atm) on my father's HP destop. When i install, the partition manager wont allow me to shrink the windows partition to fit ubuntu in, and when i go to gparted to do it manually, it says that there are damaged sectors. is there a way to force ubuntu to install?
View 2 Replies
View Related
Oct 25, 2010
This is my partition table:
/dev/sda1 1 4255 34178256 83 Linux
/dev/sda2 4256 4437 1461915 5 Extended
/dev/sda3 * 4438 9964 44395627+ 7 HPFS/NTFS
[code]....
View 4 Replies
View Related
Apr 20, 2011
using onboard windows disk management i have made 75gb unallocated to add to the aforementioned ntfs data partition. but, after resizing extended partition, will i need to fix grub even though i will be adding the unallocated space to a storage partition and not the ubuntu boot partition?
View 4 Replies
View Related
