Server :: Database Stopped Showing Up - Files Still There - Restore The Database From The Files?
Jul 8, 2011
I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?
View 2 Replies
ADVERTISEMENT
Mar 22, 2011
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 Related
Nov 8, 2009
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]....
View 3 Replies
View Related
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)
[code]...
View 2 Replies
View Related
Jul 2, 2010
I don't have any idea where to place the "mysql-connector-java-3.1.14-bin.jar" file in ubuntu 9.10. Yesterday I did this in xp successfully by placing this jar file at following locations
Javajre1.6.0_06lib
Javajre1.6.0_06libext
Moreover, the jar file which I am using for xp; can be used for ubuntu 9.10 or not. I am using NetbeansIDE 6.7.1 (installed from Software Center), MySQL 5 Server (sudo apt-get install mysql-server) is this enough?
View 2 Replies
View Related
Sep 4, 2010
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 Related
Jun 1, 2010
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.
View 8 Replies
View Related
Jun 20, 2011
i am new to python programing and i have a couple of ?'s
1- what would i do if i needed to find the closest, bigger number, from a list of numbers when the user types a number in.
2- (windows) i need a program that can compile .py files into a .exe file so that it works on a machine without python it also needs to work with python 3.2.
View 8 Replies
View Related
Jul 8, 2010
I was hoping to get some pointers on how to rename files based on database entry. I got hundreds of thousands of files that has GUID name assigned to it. only way to find out the file name is to look up the database table. Its obvious that this is not efficient. I couldn't find any tutorials on how to do this. Please point me to right direction. A starting point would be very helpful.
View 1 Replies
View Related
Dec 7, 2010
I've a program which manages my pdf and references. I wish to put some of the information on my website but that program (Mendeley) does export only in XML (or bibtex). I'd like to simply convert the XML output files to SQL in order to create or update an SQL database.I'm not an expert in either XML or SQL (use only PHPMyadmin). Does someone get help me to figure out?
View 2 Replies
View Related
Feb 15, 2010
I'm looking for a simple and reliable search engine for searching particular content on the files in the storage database. The output will display files' name and their path. Google search found following site:- "List of search engines";[URL]..There are many of them. I have no idea how to make my selection. Could you please shed me some light. Furthermore can a simple shell command do the same job?
View 4 Replies
View Related
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
May 24, 2010
I am running tests on doing a postgreSQL restore, and part of the procedure is to import the dump file into the database. The database, version 8.1.3,s from HP-UX Internet Express Version A.14.00 Bundle and was installed onto an HP-UX 11.11 server.As part of the testing process, I was planning on setting up a Linux system with the latest available version of PostgreSQL, and import the dump file generated on the HP-UX server into database on the Linux system. Once that was done, we would connect to the latter system, and test the database.My questions are the following:1. Can the dump file be imported to a remote system rather than the one that generated it?2. Is this a good test to determine the viability of the dump file?
View 6 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
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
Oct 17, 2010
I know I've got inotify-tools installed; I've got a daemon that runs and it's using inotifywait to move some files around.
This thing is:
12:20:16 /home/barrie $ >> dpkg --get-selections | grep inotify*
12:20:29 /home/barrie $ >> aptitude show inotify-tools
Package: inotify-tools
New: yes
State: not installed
Version: 3.12-1
Priority: optional
Section: misc
Maintainer: Peter Makholm <peter@makholm.net>
Uncompressed Size: 115k
Depends: libc6 (>= 2.6-1), libinotifytools0
Description: command-line programs providing a simple interface to inotify
inotify-tools is a set of command-line programs for Linux providing a simple interface to inotify. These programs can be used to monitor and act upon filesystem events. inotify-tools consists of two utilities:
inotifywait simply blocks for inotify events, making it appropriate for use in shell scripts.
inotifywatch collects filesystem usage statistics and outputs counts of each inotify event.
12:20:40 /home/barrie $ >>
It's not showing up as installed! If not how to get the list of installed packages 'reloaded'. I've googled for hours and reloading the installed packages doesn't look promising!
View 3 Replies
View Related
Nov 3, 2010
we have Centos linux and database postgresql and taking dump in .data files. need to find all speical character in my database dump .data files it is open in txt paid and store in one txt file. e.g of special character are as below.
[Code]....
View 1 Replies
View Related
May 9, 2011
I got the following task from my boss. I have to find out if there is some alternative tool for create reports from Squid except SARG. Now, we use SARG, but my boss told to me, that the main problem of SARG is, that SARG generate huge amount files, which cause problems during migration our servers. He told to me the following condition for change of current tool (SARG):
* standard package of Debian
* generate less amount of files, optimal is to save reports to the database
So I would like to ask you if you know about some tool (I can not find some by google)... and the best would be if you told to me some practical experiences.
View 1 Replies
View Related
Jan 5, 2011
I am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies
View Related
Feb 11, 2010
i have ubuntu karmic 9.10 and when i try to update anything or install anything the a very similar error occurs."(Reading database . . . 55%dpkg: unrecoverable fatal error , aborting: files list file for package `com.palm.net.precoddr.fcoaster' contains empty filenameit repeats this message 3 times then gives up i believe.
View 9 Replies
View Related
Jun 16, 2011
I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
View 10 Replies
View Related
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
Jun 29, 2010
I'm trying to restore all my files to my new ubuntu server (a netbook actually) and can't! after copying for a few moments the samba shares stop working. in synaptic it says samba 2:3.4.7 as im typing this i realized I was able to copy a few large files when i was starting out so there may be some software added since thats the issue. In my scenario i found that the server does recover after a minute or two. but when copying large files it causes ALL networking to stop. funny that if i go to the server screen it is fine. Ive experienced this connecting with a windows 7 pc and a mac. the server will start responding again in a couple of minutes. when it locks up it locks up ALL networking: cant connect to the webserver, or ssh either when this happens. Just starts working again after 2 minutes. I am unable to sync this with my backup drive unfortunately.
I did some experimenting today and found that I was able to stay connected via ssh for well over an hour with no problems. as soon as I start copying files is when it happens. I use this as a server in a home office so I need to resolve this. for now going to share a drive off my router i guess. have been poring through the logs and reading everything i can on this the last few days.. I switched from network manager to WICD after reading about it online somewhere. that actually did help to apparently reduce the frequency of the issue.
does anyone have any tips? this is a new machine/install of Ubuntu 10.4 LTS desktop version (its just easier than the server version for me even though using as a server). its a new MSI X Slim X320. I bought it as it has the X530 Atom processor which is super efficient and I run this as a solar powered web/file/torrent/app server. In that regard im very pleased with it.
View 5 Replies
View Related
Apr 19, 2011
I've installed PostgreSQL on Arch Linux & also self generated self signed certificates in /etc/ssl/ directory. My PostgreSQL 'data' directory is /var/lib/postgres/data & I've edited my postgresql.conf file to use SSL however I'm having permission / access problems starting my database using SSL. It can't access the certificates and errors out when I try and start the database engine:
Code:
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
FATAL: could not load server certificate file "server.crt": No such file or directory
code....
I don't know what I need to chown or chmod in order to get PostgreSQL to access my self signed certificates.
View 3 Replies
View Related
Nov 4, 2010
I am now able to create the database using PHP and SQL. But it seems I can only do it as MySQL root user.. $dbuser = 'root'; but is there a way to do that as a regular MySQL user?
View 2 Replies
View Related
Nov 8, 2010
I have got 2 postgresql databases on separate servers. i want to sync one database to the other. how it can be done ?
View 1 Replies
View Related
Apr 19, 2011
I switched from Windows 7 to Linux and when I'm trying to import my database i get error 1044. It used to work when I was using Windows 7. I was able to export the database from my localhost. However, when I try to import it to the other server I get this:#1044 - Access denied for user ' '@'%' to database'.I have been trying for hours to upload my site from the localhost to another server without any luck..I'm using phpmyadmin to import it.
View 2 Replies
View Related
Dec 26, 2010
i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password
createdb company
Password:
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
View 1 Replies
View Related
Dec 10, 2010
I have suse linux 10.1 that came with whats looks to be a incomplete sql server. If it works I don't know how to use it because w3schools instruction guide does not work with sql. Anyways I was wondering if there's any database software for linux that could be installed in my webpage directory and used by html files. Or if theres any free cgi database software for linux that i could use with html to create database web pages.
View 3 Replies
View Related
Feb 15, 2010
I'm migrating a mailserver from an old to a new mailserver. The new mailserver is based on ISPConfig 3.0.6.1.
I would like to migrate what spamassassin learnt in the past from the old mailserver to the new one. Now the question:
- The 2 spamassassin versions are different. Is it a problem?
- Can I just migrate the database with this commands???
Code:
sa-learn --backup > sadb.bkp
sa-learn --restore ./sadb.bkp
-how to migrate SpamAssasins Auto White List and all others SpamAssassins databases?
View 3 Replies
View Related
