OpenSUSE :: Test Out Restoring The Database?
Sep 19, 2010
I currently backup my database using MySQL Administrator. I wanted to test out restoring the database, so on my test server I deleted the database and restored the .sql file to a new schema with the same name as the old. one. It appears to complete the process just fine. But I noticed that the number of rows for the restored database is slightly less than what was backed up.
Is this normal or should the numbers be exactly the same? It's only a difference of about 28 rows. I seem to be able to view the data just fine in the query tool.
View 4 Replies
ADVERTISEMENT
Jun 9, 2010
We have a disaster recovery solution for our database where a dump file is generated daily at 1:00 AM. We have tested importing the file, along with running another sql file that generates the appropriate database user accounts, into a database on a third-party server.
One question that came up was the following: Suppose the database crashes in the middle of the day, prior to that there were transactions that were entered into the database between the time the dump file was generated, and the crash occurred. We can restore the dump file to either the main or backup server. How can the transactions that were made between the time of the dump file and the crash be restored as well?
View 2 Replies
View Related
Oct 14, 2010
in my fedora machine i gave
mysqldump <database-name> > bakup.sql
in my solaris machine i gave
mysql <newly created dbname> < bakup.sql
it shows the below error
ERROR 1064 at line 25: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7
mysql version in my fedora machine is
mysql Ver 14.14 Distrib 5.1.47
mysql version in my solaris machine is
mysql Ver 12.22 Distrib 4.0.24
View 4 Replies
View Related
Feb 8, 2010
mysql -u root -p but unable to create any database.
if i tried to configure it's giving error ERROR 1006 (HYOOO) : can't create database 'test' (error: 2)
my location for database is /var/lib/mysql and permissions are
drwxrwxrwx mysql root.....
View 1 Replies
View Related
Jun 7, 2010
I have a little C++ program that I am attempting to connect to a test database.
#include <iostream>
using namespace std;
#include <sqlite3.h>
int main ()
{
int rc;
[Code]....
When I compile this code, I get the error: undefined reference to `sqlite3_open' I added sqlite3 package using the command 'apt-get install sqlite3'. Unfortunately the sqlite3.h header file was not installed in /usr/include, so I downloaded the SQLite3 dist., untarred it and copied the sqlite3.h file to /usr/include. I saw on a previous message that I would need to link the library. The only library file in /usr/lib is libsqlite3.so.0, so the command g++ -lsqlite3 still gives me an error.
View 5 Replies
View Related
Aug 27, 2011
I turned my laptop in for repairs. I used someone else's USB drive to hold my pictures etc from that computer. I may have replaced the "pictures" folder tat was already on there, but I'm not sure if it was there in the first place. (Doesn't remember the "Are you sure you want to replace..." warning <.< >.>) I enabled hidden files, and there was a folder called .Trashes, instead of what you'd normally get. I copied my pictures onto my desktop, and then cleared the ones on the USB drive (left the folder). There was a folder named .000Trash-, or whatever it usually is. Only my pictures are in there. I'm confused, and don't tell me the pictures that were originally on the USB are gone forever.There's a tool for Windows, called Glary's Uilities that can get them back, supposedly. Not running windows, though
View 4 Replies
View Related
Jan 8, 2011
To fix a Windows problem with hibernation, I had to let it overwrite my MBR. I can still boot into openSUSE 11.3 thanks to a wonderful piece of freeware called Plop Boot Manager, but the GRUB menu is no longer in my MBR (obviously).How can I force a rewrite of GRUB to the MBR from YaST?
View 9 Replies
View Related
Jan 18, 2010
I've lost my GUI while attempting to install the latest ATI proprietary driver. I followed their instructions on how to uninstall it but it didn't give me my GUI back. How do I get back to the default drivers that came with my installation? I have a Radeon 3850.
Booting into safe mode doesn't give me a GUI.
I want to try to reinstall the ATI proprietary drivers eventually. I have them on the hard drive, but I have had no luck installing them using the CLI so far.
View 4 Replies
View Related
Jul 27, 2010
I am running OpenSUSE 11.3 GNOME, and I recently reinstalled Windows, and it overwrote GRUB. I only have an Ubuntu LiveCD (I installed with the OpenSUSE DVD), how do I get GRUB back? Note that the Ubuntu LiveCD doesn't recognize the LVM Encrypted partition, so I can't mount it.
View 2 Replies
View Related
Sep 29, 2010
I've recently performed a clean upgrade from 11.0 to 11.3 (wipe / partition to ext4, retain /home disk, swap partition etc.) and everything is fine, installed as Gnome distro with KDE3 from repos.Anyway, I've noticed that SuSE will say "doing fast boot" and suspend any console spew until after the kernel has finished with hardware detection and the like. I'd like to be able to see exactly what's happening with the kernel at boot, as I'm quite paranoid and in the event of system failure etc. it would be difficult to view the logs post-boot. Also, my IDE optical drives have a habit of sometimes only being partially detected due to the power line being somewhat intermittent, and I've seen the kernel attempt to re-stablish a link on 11.0, whereas I'd never be able to see that in 11.3 unless I see the console spew, so it would look like the system hanging on "doing fast boot".
Note: I do not want to disable splash=silent, unless spalsh has another option which will give me the desired functionality. I want to have a silent boot, with the option of going verbose with Esc; it's one of the things that I love about SuSE.Oh, and Grub was a nightmare as usual with disk ordering differing at run-time from config file and the total freeze at "loading stage2", so I had to manually fix that. Why does the installer seemingly ignore or revert the specific options I set for GRUB? I understand that the default options for GRUB are ok for single disk users, but my disk ordering is not overly exotic. I stress that this was not user error, as I've had the same issue from going from 10.2 to 10.3 to 11.0, even though they were clean grub installs (rewrites). /rant.
View 1 Replies
View Related
Jan 31, 2011
I've recently begun using PING (Partimage is not Ghost) imaging software, and it works great with other Linux distros. Upon my first use on openSUSE, I found that I could not restore the image onto another computer. After a successful restoration of the image, I get: "Could not find /dev/mapper/isw_ddedgibjfd_ARRAY_part2 Want to fall back to /dev/mapper/isw_ddedgibjfd_ARRAY_part2? (Y/n)" during the first boot. I don't know what to do, I've tried taking multiple images, and restoring them on multiple computers, but I always get the same error.
View 7 Replies
View Related
Mar 29, 2011
recently I've installed Opensuse 11.4 dual booting beside windows 7 . now I want to restore windows 7 boot to remove OpenSuse 11.4 ...I've tried many ways to remove grub and restore window's boot . I tried bootrec /fixmbr and bootrec /fixboot but in when it comes to the last step it says (cannot find system path )I also tried nt60sys method to restore windows boot and it failed 2 sound like the grub installed is rock solid one
View 1 Replies
View Related
May 4, 2011
We are looking for a solution that allows us to restore a servers "identity" in the event of hardware failure...ie Name, IP address, dhcpd, named configs etc.
We have ISO images of the appliance images that contains all the software and stuff. There is no real data on these servers.
If we backup the entire ETC directory and perhaps the /var/lib can we simply restore that and get everything back?
What concerns me is how some versions of Suse use UUID for the network config and the mounts points.
View 9 Replies
View Related
Sep 16, 2010
Right now I have a OpenSuSE 11.1 server running on a single hard drive. I want to install the HighPoint RocketRAID 1740 card and utilize RAID 10.I wanted to know if the following process would work ok:
1. Image the current hard drive using clonezilla and remove the drive.
2. Install the RAID card with 4 hard drives of the same make and model as the current drive
3. Create the logical volume
4. Restore the image to that volume
Since I am restoring the image to a RAID volume, is that completely transparent to the OS? Or do I need to do a clean install on that volume and reconfigure everything?
View 4 Replies
View Related
May 29, 2011
(Just to clarify: This has nothing to do with the 11.4 mount problem with external NTFS drives that is stickied in this forum.)
I have this 2 year old WD Elements drive (500GB) that is NTFS formatted and that I've used for backup all this time, until a few months ago it failed to be recognized by any computer. The power supply is working, so I first requested a new cable, which didn't help, and now I received a replacement. But still I would like to save some of the data on the hard disc. I need to have this figured out within this week as I have to return the old drive, or they will charge me for the new.
So far, the only software to still recognize the drive was a WD analytical tool for Windows. It didn't find any problems or show any error messages as far as I could tell. They recommended using testdisk to recover the data, but testdisk doesn't recognize the hard drive in the first place. I also tried KParted, but no success.
View 8 Replies
View Related
Apr 8, 2009
I have installed Postfix + Amavisd-new, then I am started all services (and configured main.cf and master.cf to use amavis).
The questions are:
1) I am trying to test antivirus scan using eicar test virus
Code:
And the message is successfully delivered to mailbox with mark "CLEAN" in maillog. But I cant see any attachment using
Code:
Where is my mistake?
2) Should I update clam and how I can do it?
3) Is spamassassin enabled by default in amavis (I have started daemon)?
4) Where configuration files of spamassassin is stored?
View 1 Replies
View Related
Mar 15, 2010
I am trying to install mysql 5.1.44..so i downloaded the binary package, i extracted it and then followed the instructions that were in the manual but i keep getting this error when running this command
Code:
scripts/mysql_install_db --basedir=/home/mosty/mysql
the error is
Code:
Installing MySQL system tables...
100315 20:07:27 [Warning] Can't create test file /var/lib/mysql/mosty.lower-test
100315 20:07:27 [Warning] Can't create test file /var/lib/mysql/mosty.lower-test
[code]....
You can try to start the mysqld daemon with:
shell> /home/mosty/mysql/bin/mysqld --skip-grant &
and use the command line tool /home/mosty/mysql/bin/mysql to connect to the mysql database and look at the grant tables:
shell> /home/mosty/mysql/bin/mysql -u root mysql
mysql> show tables
View 1 Replies
View Related
Mar 26, 2011
I have created mobility of 20 nodes and vbr traffic using following attached script I executed the file as ns234 vbr.tcl I got the vbr.tr and vbr.nam but I was unable to load the graph using matlab <trgraph> I thought problem with is vbr.tcl script.
View 1 Replies
View Related
Mar 7, 2011
am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies
View Related
Jun 12, 2011
Sound is not working. Clean install new home. Fully patched and multi-media stuff installed. It works in test in yast but nothing else has sound. There is a loud click when KDE starts. Also there is a delay before I can do anything. Tried changing the backends no luck. Also tried disable of phonon in Yast but have nor tried to remove it yet. Perhaps I should.
sound device nVidia Corporation CK804 AC'97 Audio Controller (rev a2)
View 7 Replies
View Related
Aug 18, 2010
Is there a way to test the integrity of USB sticks?
View 4 Replies
View Related
May 7, 2011
I just installed openSUSE 11.4 on my 2 home machines. My home network lies behind a nat router but I still use the external zone setting for my firewalls. In the past to enable network printing between the two computers I opened TCP and UDP port 631. Yast would then see the remote printer, set it up and all was good. This time Yast sees and sets up the remote printer as usual. When I print the test page nothing happens. Checking the cups admin page at localhost:631 on the host machine shows the printer is set up to share but nothing is in the print que. Printing works just fine on the host computer.
View 2 Replies
View Related
Aug 16, 2010
My existing MySQL database is running on 11.1. I plan to do a fresh install of 11.3 in order to utilize the trimming feature for SSD drives. How should I install my MySQL database to the new version? Do I perform a backup then restore to the new install? Or can I just save the mysql db files to a cd and somehow attach it to the new install?
View 2 Replies
View Related
Nov 29, 2009
After installing 64 bit 11.2 with no apparent problems: computer hangs up on desktop boot opensuse 11.2-2.6.31.5-0.1, however I can boot from failsafe opensuse 11.2-2.6.31.5-0.1. I had problems trying to install Ubuntu so I checked out the opensuse. I do not know if this is an easy fix! I decided to avoid buying anymore windows system software. I ran memory test with no problems. The firmware test reported 4 errors. I have windows XP installed on other hard drive - no problems there.
View 5 Replies
View Related
Jul 12, 2010
From the start-up manual I know the Firmware Test Starts a BIOS checker that validates ACPI and other parts of your BIOS. I noticed there are 3 failures in the result. (The font size on the screen is too small for me to read.) I got stuck in trying to save to either of the two choices provided with names I don't understand. I had to use the three-finger salute to bail me out.
View 4 Replies
View Related
Apr 11, 2010
Using OPenSuse 11.2 KDE 4.4 on MSI CX600 laptop. Sound only works in the hardware test, nowhere else. Everything else seems fine, even wireless just worked after an running an update.
View 4 Replies
View Related
Mar 17, 2010
Looking for a recommendation on database development software. I tried Openoffice Database. The program crashes frequently when establishing relationships. If the data types of the relationship disagree, the program crashes. Also, the screen for establishing relationships is too small. I will probably need about 40 tables, and the Openoffice relationship map can realistically handle only about 12.
Apparently Access is up to the task of the development. Ultimately, I want to convert the developed database into a LAMP Web application. Also, I'm thinking of jobbing out much of the development. Is their an equivalent Linux-based solution, or should I hold my nose and go ahead with Access and Windows?
View 8 Replies
View Related
Aug 30, 2010
how to rebuild the system update database?
View 5 Replies
View Related
Oct 25, 2010
I have OO.o 3.1.1.4 installed on my SuSE 11.2 system. (It came with it.)I've tried connecting to my older OO.o address book database and it seems to have connected (I get no error messages) but when I try to open the database source from within Writer, or any other OO.o tool (either by pressing F4 or going to View > Data Sources) OpenOffice crashes. I can open my database as an .ods or a .dbf or .odb.When I open it as an .odb, I end up with some sort of form wizard designer. All looks ok, the table is there (and it looks good!) but then what? If I close that wizard, the table then closes with it.
I've also used File > Templates > Address Book Source. After using that, if I hit F4, OOo crashes.My main problem is that OO.o crashes when I try to view the database source from within a document.P.S. I do have Java (Sun's version of Java 1.6.0) installed and OO.o seems to know it's there and is registered.
View 8 Replies
View Related
Aug 26, 2010
Does there exist in the openSUSE 11.3 repositories gui software to test my Motehrboard and CPU? I searched under test in the description and did not see anything.
I am mostly interested in how hot my processor would get if it was actually running 3.5 gHz on all 4 cores for any length of time. Nothing I am able to do bumps the CPU speed off of 800 mHz for any real length of time.
View 9 Replies
View Related
