Server :: Import A Database File In Mysql?

Nov 1, 2010

i am having a problem while hosting a website on rhel apache server.when i write the url on browser than its doesnt show any page ,neither it displays any error.However when i am hosting a simple php webpage apart from that website its works fine.i also want to know how can i import a databe file in mysql which is a part of that website.

View 3 Replies


ADVERTISEMENT

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

Software :: Connecting To Mysql Database - Can't Connect To Local MySQL Server Through Socket

Aug 25, 2010

I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:

Code:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.

Code:

View 4 Replies View Related

Server :: Import Base.ldif Into Database?

Sep 9, 2010

i have configured ldap server on a Debian5. But Am failing to import base.ldif, mygroup.ldif and myuser.ldif into my ldap database. How can i do that?

View 1 Replies View Related

Server :: Import CSV Into MySQL?

Nov 16, 2010

I'm quite a newbie when it comes to MySQL but i heard that its possible to import data from a CSV into a mysql table.

Can anyone enlighten me on how to do it please? Im running CentOS and usiong MySQL Workbench to connect and run queries.

I have my CSV formatted so that the first row has the names of my columns on the table that I want to import it to and the following rows are the data that needs importing.

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

Server :: How To Import Database And Its Tables To Rhel4 Inorder To Working Website Properly

May 31, 2011

I have created a website in php.wamp server is used to run the site.i created the database in phpmyadmin using mysql.These all were done in windowsXP.Now I want to import it into redhat linux system.how can I import database and its tables to rhel4 inorder to working the website properly

View 7 Replies View Related

Networking :: Database Error: Unable To Connect To Database:The MySQL Adapter "mysql" Is Not Available

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

Programming :: Translate Data From A CSV File To A MySQL Database?

Aug 26, 2010

I have a CSV called source1 with data like:

Date12:00:00 AM12:30:00 AM01:00:00 AM01:30:00 AM02:00:00 AM02:30:00 AM03:00:00 AM ...
07/31/1051.5252.4852.6452.863.3663.8445.6 ...
08/01/1049.4449.9261.2860.1652.6449.1247.52 ...
08/02/1049.1248.9648.9650.7260.1658.0851.04 ...
08/03/1060.3260.6459.260.9637.9233.2832.8 ...

[Code].....

Also, the CSV file is updates every few hours and I need to load any new data from the file to the database without creating duplicates of data that has already been loaded to the database.

View 6 Replies View Related

Server :: Mysql - Cannot Create Database

Jul 28, 2009

I tried creating a database in mysql but couldn't do so...here is the message i got from the shell:

Code:

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)

[code]...

View 2 Replies View Related

Server :: Connecting To A Mysql Database Using Php

Feb 28, 2010

Well i have got a problem with connecting to a mysql database using php. I used this package "mysql-noinstall-5.1.44-win32.zip" and extracted it to c:mysql and added c:mysqlin to the PATH variable and used the following command in command prompt to start mysql: c:mysqlinmysqld --standalone

well mysql did start and everything went well accessing mysql in command prompt. Well under the database "mysql" in the table "user" i created a new user "php" with a password="****" and hostname = "localhost" but when i try to access this database with a following php routine:

And when i accesses it with my browser using localtost/test.php, all i get is "localhost" displayed on screen, "Connected to mysql" never gets displayed not i get any error..i am using windows 7(32-bit-ultimate)and mysql 5.1.44.

View 8 Replies View Related

Server :: Using One MySQL Database For Many Programs?

Jun 18, 2009

I am wondering whether it is problematic to let several different programs/php-scripts use the same MySQL-database concurrently, provided that they do not use the same tables?

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 :: MySQL Database Recovery From Files

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

Server :: Mysql Error While Creating Database?

Jul 28, 2011

while creating a new database iam facing the below problem

mysql> create database auto-download-gta; ERROR 1064 (42000): 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 '-download-gta' at line 1

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

Software :: Having Small Project Of Php Script And Mysql Database - How To Configure In .deb File

Jul 25, 2011

make deb package with samll project of php and myysql database such as login.php, index.php controll.php etc and database_name.sql. when i install this deb package my php script folder should go in /var/www file and databse should create automatically. i edit the control file of deb package , in depends line i set apache2, php and mysql because these three thing are necessary to run my script till here it is ok .but i am not able to send my project in /var/www and configure database automatically . i think for this i have to write .sh file but i dont know bash scripting

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

Server :: Sync MySQL Database And HLDS Data On Lan?

Mar 4, 2010

I have try to sync my MySQL Server database and HLDS Data on lan,one is windows server 2008 and one is Ubuntu Linux 9.10 i have try to use the remote address(192.168.0.4:3306) but can't connect and say the error code is 10060 i have check the connect is normal and ok,the accont is can let any address to contro.

View 1 Replies View Related

Software :: Connecting To Central Mysql Database Server

Sep 17, 2009

We are hoping to build a central database server so that we can take all the singular instances of mysql off our web servers and have the data stored in one place (we also run a number of syslogging servers that use mysql, netflow servers that use mysql, and many other servers that have mysql tables that we would like to consolidate as well). Now I have run into the problem that requires all the customer web sites to change the configuration for their connection to the mysql server from a local connection to a remote connection, which is something we are trying to avoid. I am wondering if there is a software suite or a function of mysql itself that allows you to present the remote database information as local databases to a server, allowing customer configurations to remain intact, as if the mysql server never moved off the local machine? Or a different question, can you configure mysql server to take local requests and forward them to a central mysql server?

View 9 Replies View Related

CentOS 5 Server :: Can't Move The MYSQL Database Files

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

OpenSUSE :: Enable Remote Access To MySQL Database Server?

Jan 29, 2011

Enable remote access to MySQL database server I used the link above to enable remote access to mysql for a specific user. But when I try to telnet 3306 or user mysqladmin to connect, both just hang there. Using mysql 5.0 on opensuse 11.1

View 1 Replies View Related

Server :: Change The Owner Of The Mysql Database With Shell Commands?

Jun 19, 2010

i want to know how can i change the owner of the mysql data base with shell commands.

View 3 Replies View Related

Server :: Mysql - Database Can Have Faults Of Safety (security) From A Certain Size

Jun 25, 2010

A database can have faults of safety(security) from a certain size, what is this size?

View 3 Replies View Related

Server :: Setup A Database Using Mysql - Always Get A Connection Refused Error

Mar 2, 2010

I'm try to setup a database server using mysql, the server starts fine, and I can access it using the built in mysql client via console (adding databases and tables works fine), but the problem is... I always get a connection refused error whenever I access the database outside the built in mysql client (example, if I write a code that connects to mysql). So, I tried execute an nmap command and the only ports open are these ports:

[Code]....

there's no 3306 for mysql... I'm thinking that the firewall is just blocking the port that mysql is using, but my question is, how could the built in client connect to the server if there's no open port for mysql server? Don't clients usually access a servers through ports?

View 4 Replies View Related

Server :: Script To Run At Boot For Auto Mysql Database Check?

Oct 27, 2010

I'm running zoneminder on Ubuntu 9.10 Even with a UPS the power quite often fails enough that I need to drive over bring home the computer and run ( mysqlcheck --all-databases --auto-repair -p ) Then enter my user PW then my Mysql PW. Both are the same. How ever if it were possible to create a script that could run at start up I could get anyone to cycle the power and let it fix it's self.

View 6 Replies View Related

Software :: MySQL Cannot Start SSH Tunnel Manager - Cannot Connect To Database Server

Jun 7, 2011

When i try to open a connection to start querying i get this message:

Cannot Connect to Database Server
Cannot start SSH tunnel manager

1 Check that mysql is running on server 127.0.0.1

2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)

3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)

4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from

View 2 Replies View Related

General :: Create A New Mysql User And A Mysql Database At The Shell Prompt?

Aug 7, 2010

How do I create a new mysql user and a mysql database at the shell prompt?

View 1 Replies View Related







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