Ubuntu Servers :: Moving Var/www And MySQL Databases
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
ADVERTISEMENT
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 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
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
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
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 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
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
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
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
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
Feb 25, 2010
I have this 7.10 Ubuntu server that I'm trying to move inside a VM on my ESXi server. I use the VMware Conversion tool and everythings goes well until I try to boot it from inside the VM, the network isn't detected. Now I understand that the drivers may not be working, I'm not an expert here. Also, since this is a 7.10 install I don't have access to the Gutsy repositories anymore.
View 3 Replies
View Related
Mar 10, 2011
I'm moving my site to a new VPS and need to learn how to move the files from my current server to the new one. I'd rather not download everything to my computer and then re-upload everything... seems like a lot of wasted time. There has to be a way to copy between the two servers, but how? I have heard someone mention rsync... is that a program I could use? If so, how?
View 8 Replies
View Related
Dec 30, 2010
im using ubuntu server 64 bit on intel atom410D. when im using my SATA DRIVE as AHCI mode while i moving 4 GB files from one partition to another my server is getting so slow that it will take me to login on ssh 2 minutes. so i have seen a thing or two about a bug on it. i changed the AHCI mode to IDE mode and now it seems to work better.
View 2 Replies
View Related
Aug 3, 2011
A while back I successfully set up a software raid (mdadm) install of ubuntu server on a cheap Compaq machine. I'm pretty sure it's running an nForce 430 chipset. Anyway, I put 3 2TB drives in it and set up two arrays: a small raid1 array for /boot and a raid5 array occupying the rest of the drives.
One point of note here is that the raid1 array never seemed to "take hold": the partition is empty, and the system has been booting entirely from the raid5 array. I'm not sure if this is relevant or not: just throwing it in there in case it is.
Anyway, I recently upgraded my desktop PC, and planned to hand down the Q6600 and DG33TL motherboard from it to the server. I did the hardware upgrade, but now the system will not boot. My question is: why.
Boot fails with the following error message:
"No bootable device -- insert boot disk and press any key"
This to me suggests that it's not even getting to the point of running grub2: the mobo itself just isn't finding anything it considers to be bootable.
I've tried all combinations I can think of of configuring the SATA support in the BIOS (modes include IDE, ACHI and RAID, all in combination with UEFI boot enabled and disabled). The system does detect the three drives: it lists them in the BIOS config screen.
I've booted from an ubuntu rescue USB drive and I'm able to see the drives and even assemble the array. I can mount the LVM partitions therein and do what I'd normally be able to do with them.
Everything *seems* fine: it just can't boot.
Grub2 is something of a mystery to me, so I'm not exactly sure what I need to do to get it booting again, if indeed it is a problem with grub.
View 9 Replies
View Related
Jul 28, 2009
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
View 2 Replies
View Related
Nov 12, 2010
I am moving some websites from a shared host to a newly configured Xen based VPS with Ubuntu 10.04. A steep learning curve but I am getting there! I have a couple of sites installed on the new server and want to test them out, from what I understand I should be able to edit /etc/hosts on my desktop computer (running Ubuntu 10.04) which should automatically redirect my browser to the new server. But it doesn't seem to work.
This is what I appended to the /etc/hosts file:
12.34.56.78 www.xxxx.com
I thought that this should send any requests for www.xxxx.com to 12.34.56.78? Some googling indicated that the browsers I am using may be using DNS caching, ignoring the hosts file. I've tried clearing the cache with Chromium 7.0.517.44 (64615) and Firefox 3.6.12, and even installed a plugin in Firefox to block DNS caching.
View 9 Replies
View Related
Apr 6, 2011
I currently know how to run a traffic report on the whole host. How can I setup a cron job to run the report on a paticular virtual host and move it to the directory where it can be view over the net?
View 1 Replies
View Related
Mar 27, 2011
I like the buttons on the left. I'm running 10.04 & I know how to move them. The problem is that changing themes will move them back right. OK, if the new theme has them on the right that's OK. But going back to the other theme doesn't change them back. They don't seem to be controlled by the theme, or I'm just not doing it right.
View 2 Replies
View Related
Sep 13, 2009
I have installed fedora 11, now i want to install touch driver for my dell 15 laptop. when i m moving cursur its moving but when i m clcking on touch pad to open anything its not opening, to open i have 2 select any file then i have to click touchpad keys.
View 2 Replies
View Related
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Jun 2, 2010
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
View 9 Replies
View Related
May 4, 2010
I don't know. I have had tons of issues with the Linux today. Now when I try and start mysql it just fails. the syslog says code...
The command mysql results in:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I have even tried to uninstall mysql and reinstall it an nothing works. Any suggestions?
View 4 Replies
View Related
