General :: Importing Database To Server

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


ADVERTISEMENT

Software :: Importing Text Files Into Mysql Database

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

Server :: Importing One Of The Python Modules Required To Run Yum?

Jun 9, 2011

I'm update Python , but founde problem root@server [~]# yum update There was a problem importing one of the Python modules required to run yum. The error leading to this problem was: No module named yum

Please install a package which provides this module, or verify that the module is installed correctly.It's possible that the above module doesn't match the current version of Python, which is: 2.6.7 (r267:88850, Jun 7 2011, 12:25:26) [GCC 4.1.2 20080704 (Red Hat 4.1.2-50)] If you cannot solve this problem yourself, please go to the yum faq at: [URL]...

View 10 Replies View Related

General :: Connect Database To Squid Proxy Server?

Apr 28, 2011

how to connect the database to proxy server.example:: this is the acl in squid.conf to block the website.the keyword that want to block store in file .txt

acl block_advertisers urlpath_regex -i �/etc/squid/
block_advertisers.txt�
acl block_entertainment urlpath_regex -i �/etc/squid/

[code]...

a bit info, the data that stored in database is a keyword to block the website if a keyword in blacklist match with the url that want access by user. if match so then the user cannot access the website.

View 6 Replies View Related

General :: Connect My Mysql Database Server From Outside Network?

Mar 3, 2010

How to connect my mysql database server from outside network. because its locally works and i cant able to connect from outside and different networks. when i try i am getting like this error.

ERROR 2003 (HY000): Can't connect to MySQL server on '123.136.126.179' (113)

View 2 Replies View Related

General :: Starting MySQL Database Server - Failed

Jul 28, 2011

Mysql can't start after I uploaded my.cnf file in /etc directory before that everything was okay but after I uploaded my.cnf and then restarted the mysql it can't boot
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
I tried to delete my.cnf and try again but the same error ...

View 5 Replies View Related

General :: Using The RHEL Server As Webserver And Database Centre?

Jul 12, 2011

The issue is i am using the RHEL server as my webserver and database centre. Now its a brand new formatted server with good amount of RAM and the usage is not much. Its being accessed locally over the LAN. But still i can see speed deficiency. Some of the pages do not get loaded and some times i can see the delays in loading the new pages. Any idea y is it so? Or is there anything i can do to increase the speed?

View 3 Replies View Related

Server :: Importing Local User Profiles To Samba?

Mar 21, 2010

how I could import local user profiles in windoz (Desktop,prefs, settings, etc) to a brand new samba server (already configured with tdbsam backend)

View 2 Replies View Related

Server :: Backup / Restore - Importing LVM Setup At Destination

Jun 8, 2009

I am doing a LVM replicate to another server.
Example: server1.foo.com has / , /boot , swap and few LVM partitions. All are in /dev/sda disk of size 80GB. /dev/sda5 is a LVM partition which has only one vg00 and it has 2 LV's (/var and /usr) and a SAN storage connected to this server which has around 500GB of single partition(a LV partition) called /data and its under vg00 .

Now I have build another server called "server2.foo.com" with same RedHat OS version - RHEL 4 and want to import the same LVM setup at destination. Down time or unmounting the filesystem is not a problem (but am trying to reduce the down time as much as possible). Is there any way that I can take a proper snapshot of whole LVM disk and restore with same setup at destination without losing the data and the lvm file system layout?

View 4 Replies View Related

General :: Monitor Database IO And Available Database Threads?

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

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

General :: Check With Nagios An Oracle Database That Is Located On A Server?

May 4, 2011

I need to check with nagios an oracle database that is located on a server. There are a lot of plugins that are provided, the problem is that the database is located on a remote server (i have an hostaddress) and then i need to log on the database (i have username and pass)So i only need to have a plugin that connects to that hostaddress and logs on, but i can't find any plugin which does that

View 14 Replies View Related

Server :: Importing NIS-Groups From NIS-Server

Jun 4, 2010

I'm trying currently to connect an Ubuntu-Box (10.04) to our NIS-Server.A few (open-)SUSE-Boxes are working since years with that NIS-Server.The (NIS-)Users can now login to the Ubuntu-Machine, but it seems that the Groups of the NIS-Server aren't imported correctly. I have a NFS-Share which I export from the NIS-Server to all the clients..What can be wrong with the configuration of the ubuntu-machine?

View 4 Replies View Related

General :: Configure UnixODBC On Rehat EL 5 32 Bit To Connect To An Oracle 10g Database Server?

Mar 28, 2010

I'm trying to configure unixODBC on Linux rehat EL 5 32 bit to connect to an Oracle 10g database server. But when I retest the connection after the configuration then The error occurs:

# isql -v oralab4_dns vonphot vonphoto
isql: symbol lookup error: /usr/lib/libreadline.so.3: undefined symbol: PC

I have searched on Google.com for 2 days but I can't resolve the problem.

View 3 Replies View Related

General :: Import A SQL Server 2005 Database From System To Remote Ubuntu Using Putty?

Jun 5, 2011

I have a database in SQL Server 2005 in my local Windows System and I want to import this database to my linux (ubuntu) server remotely using putty.

View 5 Replies View Related

General :: Importing Python Script

Apr 8, 2011

I am able to import file.py in my C program(main.c), but unable to import this file [url]

Im using centos5.5 with python2.4 using this command to run it: gcc -o output pythonembed.c -lpython2.4

How can i import this script:
[url]

View 4 Replies View Related

General :: Importing Csv File To Evolution (ubuntu 10.04)?

Jun 22, 2010

when I save my Google contacts to csv file and import to evolution the contacts are missing most of it's information. some have part of their names etc... how can i add my existing contacts so it's complete. Do i need to save it to a different type of file?

View 2 Replies View Related

General :: Importing Eudora Mail To Thuderbird?

Sep 26, 2010

I have a copy of old Eudora mbox files. I need to import them to Thunderbird. When I use the Import function, it does not provide a way to locate the mbox files. I've even installed the OSE Eudora, but, how that looks just like Thunderbird. Forks? Again, Eudora does not provide a way to import the files directly.

View 1 Replies View Related

General :: Application Running As User Foo Log Onto Database As (database) User Foobar?

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

General :: Importing User Accounts/passwords From Another Machine?

Jun 10, 2010

I have couple of users in one machine. I can access the /etc/passwd,/etc/shadow and /etc/group files in this box. I have another box. I want to create some user accounts in the second box by just looking in the passwd, shadow and group files in the first box. I would just copy over the corresponding lines into the corresponding for whichever accounts I want to create as new and also change the lines for which I want to update the account information. Is this possible and will also the passwords work fine? Please also let me know there is any good tool for automatically doing this kind of stuff. Both the boxes that I have are Ubuntu machines though one is running Ubuntu 8.04 and the other is 10.04.

View 5 Replies View Related

General :: Importing Video From Camera Into (Lucid) Via Firewire (4 Pin)

Aug 3, 2010

I want to import raw High Def video into my computer so I can edit it on Cinelerra. Ubuntu doesn't allow you to use the ieee 1394 cable by default and everything I've tried to make it work, hasn't!!I don't want to go back to windows, pay a ton of money for some video editing software when there is an excellent video editing program already on my computer.]

View 4 Replies View Related

General :: Importing Data In OpenLDAP From Remote Active Directory

Mar 10, 2010

I am running an openldap server on fedora core 10 and now running into a need of get all users data from Active Directory. Actually I have a php based application which will be using that data from OpenLDAP and it will need to be updated on weekly bases. how can I do it and any script.

View 1 Replies View Related

Software :: Importing A Vmware Virtual Machine File Vi Vmware Server 2.0.2?

Jul 27, 2011

I completed the installation of VMWare Server 2.0.2 onto a CentOS 5.4 64-bit distribution. There is a VMware virtual machine file on the server in question, and I want to activate it through the application console.

I did not see anything readily apparent that would facilitate the importing of the virtual machine file. Does anyone have a procedure that can accomplish this task?

View 5 Replies View Related

Server :: MySQL Move Database / Server Doesn't Start

Nov 3, 2010

I'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.

View 6 Replies View Related

Server :: Slow Database Server On Processing / Make It Up?

Apr 15, 2010

I'm having trouble with my database server run with PHP & MYSQL; i just installed this system on a SUSE Linux Enterprise Sever; the Server its self is an HP Proliant ML370G with 4GB RAM
The system was fine for like 3 weeks until recently when it started slowing down. Apparently, eveything is normal when you are accessing the server, for example when you are browsing on the database web interface; but problem is when you start working in the database, when you try submitting into the database, its really slow on processing, i have to first restart the mysql;
Could it be RAM? or the SQL itself?

View 3 Replies View Related

CentOS 5 Server :: Put A MySQL Database In A Server's Memory?

Mar 18, 2010

I'm looking for a way to put a MySQL database in a server's memory. The disks aren't fast enough to keep up with the usage and I don't feel like going for a splitted web&db server yet because of the costs.

Because this involves risks (unless there's a way to read from the memory and write to the memory AND disks?), so I'd prefer that the DB gets copied automatically every hour or so to the local disks.

View 1 Replies View Related

Server :: Database Can't Use SSL Certificates?

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

Server :: Create New Database From PHP / SQL

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

Server :: Sync One Database To Other?

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

Server :: Cannot Create Database In PostgreSQL

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







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