Ubuntu Servers :: Restore MySQL Databases From Files?

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


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)


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

Ubuntu Servers :: 10.04 - How To Sync MySQL Databases

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

Ubuntu :: Reinstalling MySQL Server - Still Have My Databases At /lib/var/mysql

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

Ubuntu :: Get MySQL Databases And MyPhpAdmin?

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

Ubuntu :: CRON - Backing Up MySQL Databases?

Sep 18, 2010

Trying to set up a backup for mySQL databases in CRON.

I've entered the following line in /etc/crontab:

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:


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

Server :: Moving Mysql Databases From Old Hdd?

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

Software :: How To Connect To Mysql Databases

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

Server :: Mysql Databases Disappeared From GUI Tools?

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

General :: Starting Mysqld Daemon With Databases From /var/lib/mysql?

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


View 6 Replies View Related

Server :: Turns Out The Drive That Stores The Mysql Databases Has Gone Missing?

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


View 1 Replies View Related

Server :: Display All Databases And Their Size Using Command Lines In Mysql?

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

Programming :: MySQL Security - Remove The Ability To Make Test Databases?

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)


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.


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%';

View 4 Replies View Related

General :: Single Disk Space Quota Across Home Directories And Relational Databases (MySQL, PostgreSQL)?

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

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 View Related

Debian Configuration :: ProFTPd Configuration - Use To Host MySQL Databases And A Few Websites

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

Ubuntu Servers :: 10.04 LTS - Mysql Fills Up / With Invisible Files?

Jul 23, 2010

I'm having the oddest problem. I use Ubuntu 10 LTS on 3 Amazon EC2 "large" instances, for Drupal hosting. All three servers are seeing the same issue, where root gradually fills up with files that I cannot see by any means. ls -a , du , nothing seems to see these files except for df. And when the drive gets full (after about a week), the server behaves as if the disk is full... so I believe that df is correct here. The moment I restart mysql, all that invisible data disappears, and everything is fine again.

The MySQL datadir is on a separate device (600GB EBS mounted at /ebs ), so it's definitely not MySQL data. And /tmp doesn't have anything visible going on; certainly not something that would take up 9gb.

I suspect that something is causing the kernel to not release file handlers correctly. For all I know this could be happening with all programs, but MySQL is the only thing running that would use enough temp space to be noticed. Each server has some applications that happen on it uniquely, but since it's happening on all of them I figure it's the common elements that count. The servers are a clean install, running Apache2 (PHP 5.3), MySQL, and SSHD. All three servers were installed from the official AMI.

View 1 Replies View Related

Ubuntu Servers :: Converting MSSQL To MySQL Formatted Dump Files?

Dec 11, 2010

Does anyone have a simple to use bash script or some such that will convert MSSQL dump files to MySQL formatted dump files?

View 6 Replies View Related

Ubuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?

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

Ubuntu Servers :: Mysql ERROR 1045 \ Trying To Allow Remote Access To Mysql?

Jan 14, 2011

i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :

/sbin/iptables -A INPUT -i eth0 -s -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address =" and nothing


View 4 Replies View Related

Server :: Mysql Will Not Restore Database?

Feb 21, 2011

I am having a problem restoring a database. Server is Ubuntu 8.04.4 LTS. It appears to wig out at a certain point, when this happens the output on the screen shows;Quote:

0,4),('2011-02-21 03:30:32','Queue Wait Outside (100)','Queue Wait Outside (100)',11,0,4),('2011-02-21 03:30:49','Queue Wait Sleep (30)','Queue Wait Sleep (30)',5,0,4),('2011-02-21 03:30:53','Queue Wait Sleep (30)','Queue Wait Sleep (30)',13,0,4)


View 2 Replies View Related

Server :: Tar Backup And Restore In Mysql?

May 6, 2011

how to take tar backup and restore in mysql,Iam new to mysql,i searched in google but i did not get the exact one.

View 4 Replies View Related

Server :: Mysql Backup And Restore Scripts?

Apr 11, 2011

writting shell scripts,i searched in google but could not get the exact,pls can anyone help how to take mysql backup & restore using shell scripts.

View 3 Replies View Related

Software :: Mysql Restore Database And Id Commands?

Jul 22, 2010

I used this command to Backup a mysql database [name is cacti]- /usr/bin/mysqldump -uroot -proot cacti > cacti-metadata-backup.sqlHow do I restore Restore this database, on a system that has a clean install of mysql on it. Also I need to restore the owner of this data [in this case cacti]How do I restore the owner and password for create a new one.

View 1 Replies View Related

General :: Restore 200+ Mysql Database With Shell Script?

Jul 22, 2011

I have 200+ mysql database dump in tar.gz format. Restoring all of them one by one is very time consuming. Is there any way so I can restore all these database in a single transaction.

View 1 Replies View Related

General :: Unconsciously Deleted The Project Files \ Way To Restore The Files?

Apr 16, 2011

I was working on my Ubuntu lab machine and unconsciously deleted the project files I was working on. I have been working on the project since last 10 days now. Is there a way to restore the files? I do not have sudo access. I was working in my home directory which is served by a common file system (serving all the lab machines).

View 1 Replies View Related

Fedora Servers :: Mysql At Boot Time In 10 / Get Mysql To Start At Boot?

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
090727 04:35:47 mysqld ended

The same init script works fine in Ubuntu.

View 2 Replies View Related

Software :: Configure Mysql InnoDB To Use Data Files Or Log Files On NFS Volumes?

Apr 15, 2010

I was reading [URL] which as the following in "Warning": Warning It is not a good idea to configure InnoDB to use data files or log files on NFS volumes. Otherwise, the files might be locked by other processes and become unavailable for use by MySQL. What does that mean, and how can one configure or check to ensure the above is being followed?

View 4 Replies View Related

Ubuntu :: Using To Restore Files?

May 30, 2010

My friend's computer is giving him the blue screen of death (have to LOVE Vista), so I decided to help him. I am pretty sure that it's from a virus that corrupted Vista, but I could be wrong, it could be the hard drive that went corrupt. Being that it's a laptop, I am hoping it's just the OS.

Now, I have Ubuntu on a disc, and it runs very smoothly. (Didn't install it, just chose run on the disc.) However, I couldn't see the files on the computer. I was wondering if there is a way to get those files without installing Ubuntu, because I am planning on upgrading the computer to Windows 7, but using the Ubuntu disc was the only way I could actually get to the desktop.

So, I guess my question is: is there any way to get the files from the computer on the C drive without having to install Ubuntu

View 9 Replies View Related

Ubuntu :: Files In Trash Need To Restore

Mar 22, 2011

I understand you can't restore files from the trash but when I right click on the trash at the top it says "restore files", however clicking on it does nothing. So I tried copying the files in the trash (160 MP3 albums)over to another folder and the only thing that transfers is each album folder without the contents. When i try to move the contents I get an error: items in the trash may not be modified. I can't move each folder individually either, same result. I am not modifying anything I am only moving it.

View 3 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved