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
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.
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:
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 RelatedI'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.
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 RelatedI 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 RelatedI'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]...
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.
I tried creating a database in mysql but couldn't do so...here is the message i got from the shell:
Code:
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]...
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.
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 RelatedI'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 RelatedMy 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 Relatedwhile 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
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.
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 RelatedHow 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)
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 ...
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 RelatedWe 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 RelatedI 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]....
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 Relatedi want to know how can i change the owner of the mysql data base with shell commands.
View 3 Replies View RelatedA database can have faults of safety(security) from a certain size, what is this size?
View 3 Replies View RelatedI'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?
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 RelatedWhen 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
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View Related
