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 RepliesI installed mediawiki the other day and went with the default innodb option. However a week later something went wrong. And since I have scripts that nightly backup /var/ I just copied the backup of /var/lib/mysql/wikidb/ (as I've done with MyISAM). Then when I connect the wikidb database. I can see the tables (via "show tables"), but when I do any query with them (check table X, select * from X) I get:
Code:
Table 'wikidb.X' doesn't exist I've since read that can can't just copy the database directory like MyISAM, and there appears to be no way that I can find to restore or fix Innodb, without a dump of the data. And I never got a chance to do a mysqldump of the data. So has anybody got any idea how I can at least view the "page" table from the files I've backed up in /var/lib/mysql/wikidb/ ?
Say i have this line in my my.cnf file
Code:
innodb_data_file_path=ibdata1:10M:autoextend:max:1000M can anyone tell me what happens when ibdata1 reaches the maximum size of 1000M? Does it break? Does it not allow writes? Does it delete old data? I searched everywhere online for answers and came up empty handed. Sorry, i know this is not an Ubuntu question but rather a MySQL question. It is running on an Ubuntu Server though
I get a SD card. Put in the SD reader. It's empty. I go to my super-important-pictures-to-a-monthly-relatory folder and select all files. Select them for MOVE. Paste them on the SD card. When the move/paste process is finished, i click on the "Eject" button on top of the SD card name. Card's ejected. I can't access the card anymore. I take out the card and put on my other computer. From 300 pictures, there are only 10 available, the remaining ones are there, but with 0bytes and unrecoveable. I panic. I go back to my main computer, my pictures are not there anymore. The pictures were on the Home folder. I panic again. I reset the computer and boot on the LiveCD. I install foremost, scalpel, photorec and about everything till my USB drive complains about being filled up. I run everything and I can't recover my files. I'm in the danger of getting fired. Things like that makes Windows sounds more appealing. When you securely remove a pendrive, things get REALLY pasted there before screwing everything up with a removal.
View 8 Replies View RelatedI have installed Xubuntu 11.04 to dual boot with older LTS version. When booting 11.04 it auto shows LTS root & home volumes on desktop. I wish to hide them (home encrypted anyway.)
View 3 Replies View RelatedAll my data is stored on a separate device/partition: a 2TB USB disk with one ext4 partition. I have 3 more USB disks: 1x 1TB + 2x 500GB = 2TB right ? I want to backup my data from the 2TB volume to the (older/slower/cheaper) other volumes combined. I am thinking to use LVM to group the 3 smaller USB disks into one 2TB logical volume and use that to back up the 2TB primary volume. Do you think that is a good idea? In case of disaster I can replace the 2TB primary disk and restore from my 2TB logical volume right ?
What happens if :
I have to replace my internal hard disk and reinstall ubuntu? Can I re-attach the logical volume ?One of the physical volumes of my volume group dies ? Can I remove it and replace it with a new physical volume (bound to have other dimensions) ?Understandably I will loose my backup data?PS: running Ubuntu 10.10 .
I would like to delete the MySQL ib_logfile but do not know where the files are located on my machine. I am running the latest version of Ubuntu.
View 1 Replies View RelatedI had a Windows XP Home box setup with MySQL, Apache, bind9, phpBB. Then one evening while preparing a Linux replacement my Windows XP Home tower died. It completely croaked. It won't boot up past POST at all. No beep codes or anything! It just sits there with the power on like a brick. I cannot boot it to grab the database through the webserver with any web based MySQL script system. I also do not have another Windows box that I can install MySQL on.
There is no possible way I have to retrieve any MySQL databases that I had on it except by mounting the hard drive where MySQL stored the databases for Windows on it. I've Googled for hours on end trying to find a solution but to no avail. I tried simply copying the contents of the database as-is from where it was on Windows to where it would be on Linux but when I try to browse the phpBB forums I get this error:
[Code]....
My server crashed due to a HDD failure, but luckily I could somehow retrieve all the files from the HDD and made an .image using dd on my workstation. Now my question is there someway to retrieve mySQL databases from these files? I hosted about 25 sites and I'm really not to into making them again from 0.
View 1 Replies View RelatedI have Fedora Core 8 installed. I would like to reinstall it so as to get back commands that have been lost. To preserve my user data that has been stored in logical volumes, what selections should I make in the installation process? Are these selections essentially the same for Fedora Core 10?
View 5 Replies View RelatedHow 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.
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.
Some a$$ hack me MySQL and deleted all my databases, I have older copies on my system, but is there a way that Ubuntu server can recall or recover deleted MySQL database files ?
View 8 Replies View RelatedWe have a MyISAM table without .MYD and .MYI files for storing data and index but we can select data from the table. We can't use mysqlhotcopy for backup the table. Each time,we execute mysqlhotcopy, we have the following error: 'dbs.table: is not base table'. How do we repair the table to re-create .MYD and .MYI files?
View 2 Replies View RelatedI am trying to install MySQL by compiling source files.Using mysql-5.1.46]version./configure --prefix=/usr/local/mysql was fine and I am getting following error while "make"
[Code]...
We have an archive server where the administrator, via a web interface, can import text files into a mysql database. The files are typically local to the machine. The operating system of the server is CentOS 5.4, and that of the mysql database is 5.0.77.The database was originally on another server which was replaced by the one that is currently in use. The migration of the database from the older server involved creating a dump file, copying the file to the new machine, and importing it into the database. The version of the mysql database on the previous server was 5.0.45. The problem that has started to occur is the following: When the administrator goes through the motions of importing a text file to the database, the text does not get imported even though there are no error messages appearing on-screen or in the mysqld.log file. The administrator can see what is already in the database, but he cannot add to it.
The web interface to the database utilizes perl modules and cgi files. I ran the cgi files from the command line to see if there were any error messages. There were none. The perl modules that were on the previous server were copied to the new server with the permissions kept intact. I also verified the user and database permissions on the new server match those on the older server. I am at a loss as to why this is occurring, and I would appreciate any help I can get on this. I have enclosed the files that are involved with the importation of the text file into the database as a single text file attachment. The files are all cgi files with the exception of the last file being the perl module.
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]....
K3B burning data and ISO files. Disc Media:Datawrite DVD & CD Discs
Old Box
OS: WinXP Pro SP3 32bit
Burning Software:Nero 7.0.1.4
Mobo:Asrock P4V88+
Processor:AMD AthlonXP 2800+ Single Core CPU
Memory:2GB DDR
Optical Drive:NEC DVD RW ND-4550A (2x, 4x & 8x write speeds)
[Code].....
My Current / Old box (WinXP)can burn 2.9GB of data over a LAN from a mapped drive using Nero in 7 minutes and maintain file & directory names as they are complete with upper and lower characters, spaces between words and special characters without shortening file / directory names out of the box. My new box (SuSE 11.2) was initially incapable of burning anything, ?Access Denied? I added the user to the cdrom group this allowed the burning of data but the process changed file and directory names. It changed all letters to capitols, replaced blank spaces and special characters with underscores. I still can?t burn ISO files, ?Access Denied?. The time it took to burn the 2.9GB of data on the hard drive of the SuSE install was sort of acceptable but a full 5 to 6 minutes longer and I was forced to shorten file names too.
I changed a setting to allow the full ascii character set hoping this would preserve file and directory names as they are during the burn process. I changed a setting to allow long file names too. I now have another problem, on starting the burn process and after a minute'sh K3B displayed the fact that it was going to take over 1 ? hours to finish! Yikes. After an hour it was going to take a further 2hrs and 10mins. This didn't include read varify. I aborted the burn process, this can?t be correct. I placed the LG drive in my old box, burn process took a second or two less than 7mins to complete using the same data over the same LAN. I've tested the drive for hardware errors, the drive is perfect. Am i missing something, failing to do something or doing things wrong. Is the optical drive or some other component incompatible in some way.
I'll be burning many gigabytes of data on a daily basis and i'm hoping to be able to burn a full DVD disc of mixed data types in less than 10mins whilst preserving the full ascii character set, file & directory names inc special characters and blank spaces. I still need to resolve my "access denied" problem when trying to burn ISO files too.
I am using ubuntu and mysql.I have a list of many .sql files, like 1.sql, 2.sql, 3.sql ... 100000.sqlI need to insert them into the database mysql mydb < *.sqlGives me: -bash: *.sql: ambiguous redirect
View 2 Replies View RelatedIs there any config files for xterm for default settings? For example, on my system, xterm start with black text on white background, and I want it the other way around. I can do it by starting it with:
xterm -bg black -fg white.
I want to set in a config file that if I run it without arguments, it will start with these options.
Does anyone know how to configure an SSL cert with GoDaddy? On the following squid page it seems to use x509 and PEM format for everything. GoDaddy seems want CSR files to issue the cert. The x509 & PEM combo don't seem to generate these CSR files in the correct format. Does anyone know the openssl commands to generate the files and the config line(s) to put in squid.conf?
I started from this wiki: [URL]
I also tried following this godaddy wiki, but it was for apache and not squid [URL]
what two files are used to configure TCP wrappers
View 2 Replies View RelatedI have a folder which includes bunch of folders each having data files in them. [ Folder A has F1, F2 F3 ..... F1000 folders in it, and F1, F2, F3 ... each has about 10 different files named FILE 1, FILE2, FILE3 .... in them.
I am interested in File 1 of each Folder, because that contains the data I need in it. More specifically, that File1 s have a line "ANSWER=..." in them, and i need to get that value of the ANSWER from each file. So doing it by hand is so hard, so I need to write a script that will scan all folders and give me a list of values of eache ANSWERs.
Finally went open source at home, but must be able to load QB to work with data files already for me to load into program. Will my system at home allow me to load QB Pro Premier 2009? Or alternative apps that will let me load and work with the data?
View 2 Replies View RelatedDoes 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 RelatedAs it says in the title I need to use the scalpel file recovery tool, or something similar to be able to recover a lost mysql storage folder.. The system crashed, and I really need these files as fast as possible. So I would love any help I could get.I have been searching in different search engines (including this forum) for an answer to my question, but I can't seem to find it.How can I configure scalpel, or any other similar application to be able to recover my mysql /var/lib/mysql storage directory. I really need these files... And.. I know, I should have taken backup
View 4 Replies View RelatedSome PDF files have a functionality that text and amounts can be filled in some parts of the file, after which it can be printed (most of the times NOT saved). Our tax authorities have these files as well, you can download them, fill in text and amounts, it even counts it for you, and you can print and send.
Unfortunately, I can't use that functionality in Evince (running Squeeze). I tried this with Adobe (also in Squeeze) and it didn't work either. In Win it does work, but of course I would like Debian to be "allround" Can it be that some application must be installed to use this function?
I am trying to set the default files created by www-data to 774 (umask of 003).
I go to
Code:
/etc/apache2/envvars
and have set these parameters. NOTE: The only thing I actually changed was adding the umask 003 at the end.
Code:
# envvars - default environment variables for apache2ctl
# Since there is no sane way to get the parsed apache2 config in scripts, some
# settings are defined via environment variables and then used in apache2ctl,
# /etc/init.d/apache2, /etc/logrotate.d/apache2, etc.
[Code]....
I'm having trouble reading EXIF data from TIFF files. Both 8 bit and 16 bit fail to load EXIF data via eye of gnome and GIMP and I'm not sure why. Neither files downloaded online nor rendered from Bibble 5 seem to work. Using Ubuntu 10.04 64bit and GIMP 2.7.2.
View 2 Replies View RelatedI have some developers with Desktop User accounts. How can I allow them to delete files owned by www-data which are created under their accounts (/home/username/public_html) by PHP scripts they are coding and testing.I tried to edit www-data user group and add the user as a member of it but this has no effect - the user still unable to delete these files only by creating another PHP script!
View 1 Replies View Related