Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Web Hosting


Advertisements:




SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Mysql Command To Make A New Database


what is SSH command - to make a new database with database name as ( ra_ra ) with database user as ( ra_ra ) and database password as 'ra'


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Is It Possible To Make Joomla Connect To An External Mysql Database Server
Is it possible to make Joomla connect to an external mysql database server?

Meaning, the database for Joomla won't be local, but on another server.

Will it work by just entering the mysql hostname, user and password in Joomla's config?

What issues might arose by doing this?

View Replies!   View Related
How To Make Scp -r Command Continue After Closing Ssh
I'm tranferring files from one server to another, and it is rather large. When I dissonect from SSH it seems like the command stops.

How do I make it continue whether or not the ssh session is still active?

View Replies!   View Related
Freeze On Running Command "make"
Recently brought a new server, works fine however when ever i run the command "make" either apache, eaccelerator or any kind of software a few seconds later the server hangs. It is then hard rebooted, no errors are shown the server just freezes.

Ive had a OS reinstall.

View Replies!   View Related
"make" Command Not Work
am trying to used "make command"

[root@box ~]# makemake: *** No targets specified and no makefile found.  Stop.[root@box ~]# 

and when i try to install it by "yum install make"

[root@box ~]# yum install makeLoading "installonlyn" pluginSetting up Install ProcessSetting up repositories base .....

View Replies!   View Related
How To Make MySQL Functions In PHP In Server
how to make MySQL functions in PHP in server,bcz when i intall VB in my dedicated server it comeing is there is any option in WHM to chnage these funtion!

View Replies!   View Related
Requota Make Server Highload And Mysql Failed
today mysql server just went down and below is ps aux result

Quote:

khuvuich 4821 0.1 1.2 34580 24760 ? S 08:44 0:00 /usr/local/cpanel/cpanel ./frontend/x3/index.html
root 4822 0.0 0.0 1980 644 ? D 08:44 0:00 quota -v
nobody 5079 0.0 0.2 9248 4612 ? S 08:46 0:00 /usr/local/apache/bin/httpd -DSSL
root 5202 0.1 0.1 12344 4060 ? Ss 08:46 0:00 /usr/sbin/exim -Mc 1IOjnZ-0001Lt-Sq
mailnull 5207 0.0 0.1 12348 2236 ? S 08:46 0:00 /usr/sbin/exim -Mc 1IOjnZ-0001Lt-Sq
root 5233 0.3 0.2 9940 5064 ? S 08:46 0:00 /usr/bin/perl /scripts/restartsrv_mysql --restart
root 5262 0.0 0.0 4580 1200 ? S 08:46 0:00 /bin/sh /etc/rc.d/init.d/mysql start
root 5423 0.0 0.0 5796 528 ? S 08:47 0:00 sleep 1
root 5424 0.0 0.0 4288 788 pts/5 R+ 08:47 0:00 ps aux
root 5592 0.0 0.1 7612 4012 ? S Aug23 0:01 /etc/authlib/authProg
root 6889 0.0 0.0 3216 644 ? D 05:00 0:00 quota -v
root 8687 100 0.0 3360 556 ? R 01:47 419:13 /usr/sbin/repquota -auv
root 8701 0.0 0.0 2196 524 ? D 01:47 0:00 /usr/sbin/repquota -auv
root 10187 0.0 0.1 7612 4084 ? S Aug23 0:01 /etc/authlib/authProg
root 10833 0.0 0.0 0 0 ? S Aug24 0:15 [pdflush]
root 11900 0.0 0.0 3340 524 ? D 02:02 0:00 /usr/sbin/repquota -auv
root 11921 0.0 0.0 2012 524 ? D 02:02 0:00 /usr/sbin/repquota -auv
root 12142 0.0 0.1 7612 4088 ? S Aug23 0:01 /etc/authlib/authProg
root 14413 0.0 0.0 2172 524 ? D 02:15 0:00 /usr/sbin/repquota -auv
root 14437 0.0 0.0 3172 524 ? D 02:15 0:00 /usr/sbin/repquota -auv
root 14534 0.0 0.0 2888 520 ? D 02:16 0:00 /usr/sbin/repquota -auv
root 14601 0.0 0.1 7612 4012 ? S Aug23 0:02 /etc/authlib/authProg
root 14805 0.0 0.0 2564 524 ? D 02:18 0:00 /usr/sbin/repquota -auv
root 14959 0.0 0.0 1848 520 ? D 02:19 0:00 /usr/sbin/repquota -auv
root 15695 0.0 0.4 20540 10060 ? S Aug24 0:01 cpsrvd - waiting for connections
root 16091 0.0 0.0 3096 632 ? DN 02:25 0:00 quota -v kd4rumn
root 17065 0.0 0.1 7612 4088 ? S Aug23 0:01 /etc/authlib/authProg
root 18882 0.0 0.0 3416 644 ? D 02:41 0:00 quota -v
root 19232 0.0 0.0 2428 644 ? D 07:14 0:00 quota -v
root 20506 0.0 0.0 3460 644 ? D 07:26 0:00 quota -v
root 20751 0.0 0.0 2896 640 ? D 07:28 0:00 quota -v
root 20808 0.0 0.0 3760 644 ? D 02:53 0:00 quota -v
root 21143 0.0 0.0 2676 644 ? D 07:30 0:00 quota -v
root 21615 0.0 0.0 3336 644 ? D 02:58 0:00 quota -v
root 21732 0.0 0.0 2076 520 ? D 07:32 0:00 /usr/sbin/repquota -auv
root 21871 0.0 0.0 3196 524 ? D 07:33 0:00 /usr/sbin/repquota -auv
root 21885 0.0 0.0 3408 640 ? D 03:00 0:00 quota -v
root 22190 0.0 0.0 2116 640 ? D 03:02 0:00 quota -v
root 22333 0.0 0.0 3196 520 ? D 07:34 0:00 /usr/sbin/repquota -auv
root 22350 0.0 0.0 2716 524 ? D 07:34 0:00 /usr/sbin/repquota -auv
root 22959 0.0 0.0 2748 640 ? D 03:08 0:00 quota -v
root 23312 0.0 0.0 3104 576 ? D 07:35 0:00 shutdown -r 0 w
root 23712 0.0 0.0 3116 520 ? D 07:36 0:00 /usr/sbin/repquota -auv
root 23941 0.0 0.0 3856 640 ? D 07:38 0:00 quota -v
root 24197 0.0 0.0 3512 644 ? D 03:16 0:00 quota -v
root 24928 0.0 0.0 2512 640 ? D 03:20 0:00 quota -v
root 25144 0.0 0.0 3844 644 ? D 03:21 0:00 quota -v
root 25830 0.0 0.0 1980 644 ? D 07:44 0:00 quota -v
root 26838 0.0 0.0 3204 640 ? D 03:32 0:00 quota -v
root 27238 0.0 0.0 3832 640 ? D 03:34 0:00 quota -v
root 27377 0.0 0.0 2912 640 ? D 03:36 0:00 quota -v
root 27433 0.0 0.0 2752 640 ? D 03:36 0:00 quota -v
root 27503 0.0 0.0 2176 644 ? D 03:37 0:00 quota -v
root 27659 0.0 0.0 2144 644 ? D 07:52 0:00 quota -v
root 27713 0.0 0.0 3832 1080 ? S 07:52 0:00 /usr/bin/perl /scripts/quota_auto_fix
root 27714 0.0 0.0 3832 440 ? S 07:52 0:00 /usr/bin/perl /scripts/quota_auto_fix
root 27715 0.0 0.0 3340 520 ? D 07:52 0:00 /usr/sbin/repquota -a
root 28543 0.0 0.0 2500 640 ? D 03:43 0:00 quota -v
root 29352 0.0 0.0 1520 576 ? D 07:59 0:00 shutdown -r 0 w
root 29417 0.0 0.0 0 0 ? Ds 08:00 0:00 [bash]
root 29538 0.0 0.2 9240 5248 ? Ss 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29543 0.0 0.2 9520 5264 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29546 0.0 0.2 9500 5232 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29547 0.0 0.2 9520 5376 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29548 0.0 0.2 9380 5416 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29549 0.0 0.2 9380 4792 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
root 29556 0.0 0.0 3180 640 ? D 03:48 0:00 quota -v
root 29597 0.0 0.0 0 0 ? S Aug24 0:09 [pdflush]
nobody 29637 0.0 0.2 10044 5624 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29763 0.0 0.2 9380 5392 ? S 08:02 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29878 0.0 0.2 9520 4868 ? S 08:02 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29939 0.0 0.2 9520 4904 ? S 08:02 0:00 /usr/local/apache/bin/httpd -DSSL
root 30271 0.0 0.0 5812 576 ? D 08:03 0:00 /sbin/quotaoff -a
root 30425 0.0 0.0 2552 644 ? D 03:54 0:00 quota -v
root 30432 0.0 0.0 2636 640 ? D 08:04 0:00 quota -v
nobody 30466 0.0 0.2 9512 4844 ? S 08:05 0:00 /usr/local/apache/bin/httpd -DSSL
root 30609 0.0 0.0 3732 640 ? D 08:06 0:00 quota -v
root 30616 0.0 0.0 2328 640 ? D 08:06 0:00 quota -v
root 30994 0.0 0.0 2464 640 ? D 08:09 0:00 quota -v
root 31071 0.0 0.0 2156 644 ? D 08:09 0:00 quota -v
root 31250 0.0 0.0 2296 644 ? D 08:10 0:00 quota -v
root 31800 0.0 0.0 3508 524 ? D 08:12 0:00 /usr/sbin/repquota -auv
root 31828 0.0 0.1 8852 2328 ? Rs 08:12 0:00 sshd: root@pts/5
root 31851 0.0 0.0 4812 1444 pts/5 Ss 08:12 0:00 -bash
root 32295 0.0 0.0 2172 644 ? D 08:15 0:00 quota -v

and top result

Quote:

8687 root 19 0 3360 556 468 R 100 0.0 422:52.37 repquota
5817 nobody 16 0 9384 4728 1288 S 0 0.2 0:00.03 httpd
6119 root 17 0 3480 1024 764 R 0 0.0 0:00.01 top
1 root 16 0 2716 548 468 S 0 0.0 0:01.37 init
2 root RT 0 0 0 0 S 0 0.0 0:02.45 migration/0
3 root 34 19 0 0 0 R 0 0.0 0:00.05 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.75 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.01 ksoftirqd/1
6 root 5 -10 0 0 0 R 0 0.0 0:04.17 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:00.52 events/1
8 root 8 -10 0 0 0 S 0 0.0 0:00.00 khelper
9 root 15 -10 0 0 0 S 0 0.0 0:00.00 kacpid
35 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/0
36 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1
37 root 15 0 0 0 0 S 0 0.0 0:00.00 khubd
56 root 16 0 0 0 0 S 0 0.0 0:48.82 kswapd0
57 root 12 -10 0 0 0 S 0 0.0 0:00.00 aio/0
58 root 12 -10 0 0 0 S 0 0.0 0:00.00 aio/1
202 root 25 0 0 0 0 S 0 0.0 0:00.00 kseriod
332 root 18 0 2356 644 560 D 0 0.0 0:00.00 quota
429 root 8 -10 0 0 0 S 0 0.0 0:00.00 ata/0
430 root 8 -10 0 0 0 S 0 0.0 0:00.00 ata/1
431 root 6 -10 0 0 0 S 0 0.0 0:00.00 ata_aux
435 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
436 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
437 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_2
438 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_3
439 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_4
440 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_5
461 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_6
462 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_7
523 root 15 0 0 0 0 S 0 0.0 0:43.22 kjournald
679 root 18 0 3516 640 560 D 0 0.0 0:00.00 quota
718 root 20 0 2648 644 560 D 0 0.0 0:00.00 quota
1017 root 19 0 2388 524 448 D 0 0.0 0:00.00 repquota
1213 root 18 0 2064 644 560 D 0 0.0 0:00.00 quota
1495 root 18 0 2124 644 560 D 0 0.0 0:00.00 quota
1678 root 18 0 3464 640 560 D 0 0.0 0:00.00 quota
1694 root 19 0 3576 640 560 D 0 0.0 0:00.00 quota

It make mysql server failed and when i try to restart got this

Quote:

MySQL manager or server PID file could not be found! [FAILED]

This issue is really strange as i never put requota to run in cronjob.

View Replies!   View Related
SCM Command? MySQL Won't Start
What command could I use to see all the currently running services on my Windows (vista) computer?

I'm trying to start my MySQL server, but it won't start. I think I know what the problem is though I'm not sure. I think that the service name "MySQL" is already running...and I need to remove it or something.

Btw...my apache and php is fine. Though...I cannot use my MySQL from php obviously...since it's not running.

View Replies!   View Related
Rsync Mysql Database
how can i setup rsync to backup just mysql database (if possible) every 6 hours or so.

View Replies!   View Related
Rebuilding MySQL Database
I have are the .frm, .MYD, .MYI how do I restore/rebuild the database?

View Replies!   View Related
Reloading A Mysql Database
My server admin linked me to this:

[url]

I'm using a cpanel based server, but I can't get this to work.

It requires I be in a directory I figure (this step isnt included)

so I type cd /home/username/public_html/

And then i follow the commands. but it doesnt work.

Basically i need to take a mysql database that I uploaded to my directory, and load it back into a database. :@

View Replies!   View Related
Get Mysql Database From Shell
I have a problem getting mysql to start, so I am planning to setup a new server and move all the mysql databases to a new server.

The problem is I normally get mysql databases when mysql is running by using mysql command lines. Now that I cannot start mysql, I cannot use that method.

Is there a mysql directory that contains all the mysql databases for me to tar it up and untar it on a different? If there is a directory that contains all the mysql databases, do I need to exclude some files/folders so it doesnt conflict with the files/folders on my new mysql server?

View Replies!   View Related
Repait All Database In Mysql
we have whm in my server

in whm is one part to name

Repair Mysql Database

this is only for one database

how may i repaired all database in my server?

View Replies!   View Related
How To Protect Mysql Database
what steps procedures need to be done to keep your database as safe as possible from the hackers. Anyway to be alert when someone got into your db and try to dump, alter your database?

View Replies!   View Related
MySQL With Huge Database
ways to improve the database performance in the situation when I have to modify a large table (several million rows), by e.g. adding a column. Currently this would take several hours which is too slow. The bottleneck is disk I/O. I am considering either partitioning the table over several innodb files on several disks, or going to a RAID-5 or RAID-10, it this will give me better write performance.

The database is 130GB large, and the problem table (which I make period changes to) is the largest table on the server. I cannot have downtime of 3 hours each time I make a change and adding blank fields (to be used later, when a new field is needed) is not an option.

Each time I add a column, the cpu goes into high (80%) io wait state for about 3 hours.

I have a hack which would allow me to split the large table into multiple smaller tables based on some criteria (for example, forumID or such). Here are a couple of things but would like to know which is best, and am open to new ideas. The ideas so far:

1. Split the table into 3 or 5 smaller tables each on it's own disk. The disk IO would then not be so bad, and it might only take 1 hour to perform the table change. But this might not work because the changes to the database (as in adding a column) might be serial, meaning only 1 disk is being written to at a time. (Then again, maybe it will work if I launch 3 different scripts, one to update each table at once).

2. Do RAID 5 or 10, and have 3 or 5 disks. This again might not help at all because of the above issue with MySQL writing serially.

I am using latest MySQL 5.0.45 with InnoDB engine on Debian etch Linux

View Replies!   View Related
Best Server For Mysql Database
Which do you recommend for mysql databases alone? around 200 - 300 connections anytime

I have heard that mySQL alone can be better on 64bit environment. How about the hardware?

View Replies!   View Related
MySQL Database Server In Webmin
I forgot the Password for the MySQL Database Server , How to recover it or change it without Known the old one ..

i have access to the SSH and webmin..

View Replies!   View Related
Optimize All Tables In A MySQL Database
how exactly it helps?

mysqlcheck -o -u...

Like what it does to "optimize" them? Does it really help?

View Replies!   View Related
How To Secure Access To MySQL Database
What can I do to secure access to my MySQL database to stop it from getting compromised from hackers?

Is there any way I can restrict access to the MySQL database to my IP only?

The database is for an IPB 2.3.4 forum and the username/password are stored in a conf_global.php file that is CHMODed 0444.

View Replies!   View Related
Move My Mysql Database To Another Server
Is it possible to move my mysql database to another server?

View Replies!   View Related
Big Mysql Database 4gb
i been trying to move my server.. But mysql database is quite big and restoring takes ages 10 12 hours.. is there anyway i can make it quick because database dump takes 10 15mins but restore takes 12hours and it should be a way to make that quick

View Replies!   View Related
Which Host For Website With MySQL Database
have just had a website created for me where I can store my photos on. It uses JSP + MySQL for the databse which stores the photo IDs, photo location etc. I want to get it up and running on the net but have no idea how to do this!

View Replies!   View Related
How To Reset Mysql Database Password
i just wanna reset my wordpress database password

View Replies!   View Related
Managed Database Hosting (Mysql)
if there are any recommendations on managed database hosting services. This will be used for a fairly large project running on Mysql DB. Due to the size and complexity of the database a lot of resources are being used, so I prefer to find a company which specializes in dB hosting.

View Replies!   View Related
Does Anyone Have Snort Logging To A Mysql Database
Does anyone have snort logging to a mysql database?

I am trying to get that to work so I can view the alerts with BASE.

I followed the instructions but snort is not logging to the DB,

View Replies!   View Related
How To Back Up Columns In Mysql Database
I have a mysql database, and what I wanna do is to back up specific columns only. For example, I have a table with 2 columns:

City, Zipcode

How can I do that with mysqldump?

View Replies!   View Related
[mySQL] Copy Colomn From 1 Database To Another
I'm trying to copy the contents of a column from 1 database to another. I need to do this as the contents in the current database have got messed up after an upgrade.

The DB structure

table forum_msgs
It contains a column called "topic_id".

Basically I need to copy over the topic ID fields from the "old" database into the "current" database into table forum_msg replacing any values that are currently in the column "topic_id"

I tried this but it doesn't seem to work correctly. Any ideas how it should be done?

insert current.forum_msgs
( topic_id
)
select topic_id
from old.forum_msgs

View Replies!   View Related
Alterntive Way For Downloading A MySQL Database
A friend of mine has an account with a hosting company that recently became unstable and he wants to move his site away.

I downloaded the files, but it now seems impossible to download the databases in the conventional ways.

I tried downloading them using their control panel (vDeck) but I get an error "File Permissions do not allow to download backup".

Then I tried to export it using PHPMyAdmin but the files either doesn't download at all, or it downloads inccomplete with the last lines having something like the following:

Cannot modify header information - headers already sent by (output started at /usr/local/apache/htdocs/phpMyAdmin-2.6.3/export.php:121

I tried to contact their support but they have no clue.

Is there any way to download the database? I thought of creating a script that would manually itterate through the tables and create an export fie similar to what phpMyAdmin creates. I don't know if this is possible, and I hope there are better ways.

View Replies!   View Related
MySQL Cannot Connect To Database Via PHP
I got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database.

It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs.

I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS.

I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem.

All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts.

I just added an hourly crontab so as to restart the MySQL server as a stop gap.

View Replies!   View Related
Mysql Database Locations In Cpanel
Does anyone know the default location for databases created through cpanel?

View Replies!   View Related
Backup BIG MySQL Database
What is the recommended method of backing up big MySQL database of size 2 GB ?

Quote:

# mysqldump gallery > gallery.sql
mysqldump: Got error: 1017: Can't find file: './gallery/10tir_user_group.frm' (errno: 24) when using LOCK TABLES
#

I checked the table, it is fine, but can't do the backup.

Quote:

mysql> check table 10tir_user_group;
+-------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+-------+----------+----------+
| gallery.10tir_user_group | check | status | OK |
+-------------------------+-------+----------+----------+
1 row in set (0.07 sec)

mysql>

View Replies!   View Related
Exporting Mysql Database From Helm
i have a fren who wants to transfer a hosting ..for a site made in php and hosted in helm...windows server...

the site uses mysql datbase but i could see no database in the database setting(of helm)...and says no database created..

in host i could see server.mysql in php database config files

i want to export database...to linux server

i have not used helm much..

where actually is database located and how can it be exported?

View Replies!   View Related
Granting MySQL Command Line Permissions To A User
Is there any safe way to grant command line permissions to a user/specific account? One that only allows them access to databases on their account.

The problem is that this user intermittently runs queries that cause their database to hang (including PHPMyAdmin, so they can't view the processlist through there), and I have to manually kill that process, because they can't.

Server is 2.4.21 with MySQL 4.0.27, admin is cPanel WHM.

View Replies!   View Related
Fetch Admin Password From MySQL Database
I have forgot the admin password for one of our application. All the users and passwords are stored in database table "users", is there any way I can get the password from the database.. any MySQL query that will fetch the admin password from that database table.

View Replies!   View Related
Simplest Way To Auto Cron A Mysql Database
I use a php script usually but that does not work for large files.

I have a 130mb mysql database on linux using cPanel.
What is the easiest way to set up say a monthly cron to back this up to the root server?

View Replies!   View Related
Backup Of MySQL Database To A Remote Server
I have a 1GB MySQL database (compresses down to 300MB) and would like an automated method of backing it up to a remote server. Both accounts are shared hosting accounts (if it matters, both are running CPanel, no shell access on either).

View Replies!   View Related
Apache: Load Vhosts From MySQL Database
if it was possible to load vhosts from a MySQL database and the only solutions i found didnt work for me. Im running Apache on Windows. Has anyone seen anything that would work with Windows? The only alternative i can think of is to read the database info using PHP and output it to a vhosts config file. I dont want to do that though because it means restarting the server to load the new config and i hear that a lot of vhosts slows the server down

View Replies!   View Related
Mysql Database Dump (150mb) Utf8
recently I had problems with backing up my ~150mb database through PHP. And I know some people are backing their databases to a dump file through terminal.

My database contains UTF-8 and other characters. I have tried simply dumping with mysqldump but I doesn't seem to work, when restoring all the characters are messed up.

Is there any command to tell that the database is UTF-8?

View Replies!   View Related
MySQL Database Service Stops From Running
I have a phpBB forum, which uses MySQl database.

For the last two months the forum has been going down every couple of days because the database service has been continuously stoped running on the server with no reason.

What can cause such a frequent database failures?

Can someone attack the forum/database/server in a way that will cause the above problem?

(there is a good reason I consider this possibility very seriously)

How can I prevent futher database failures?

View Replies!   View Related
What's The Easy Way To Backup Websites/mysql Database
Due to LayeredTech price hike, i'm going to cancel my server with LT within two weeks.

Does anyone know an easy way to backup all the domians and mysql database in FreeBSD/DirectAdmin? Is there a built in feature in DirectAdmin that can do that?

View Replies!   View Related
How Do I Change Mass Database Names In Mysql
How do I change mass database names in mysql?

I have hundred of database names with "$" in the name? How do I change all instances of "$" with "_"?

View Replies!   View Related
Restoring MySQL Database From Raw Files
Is there a way to restore a MySQL database from the files located in /var/lib/mysql?

Unfortunately I don't have a mysqldump of the databases, just the raw files from an image of the server.

View Replies!   View Related
Hosting For MYSQL Database With 400 Plus Threads
I have a website that runs off a mysql database.

The first month it hit in excess of 400 threads.

Would anyone know whats the cheapest alternative to run a a site this size. Would a VPS account handle it?

View Replies!   View Related
Copying (MySQL) Database Without Panel Access.
A customer would like to move his hosting from another host to me. But the other host does not want to cooperate and give me access to the panel or files. Threw the customer I did get the ftp information, and within the config file I have the database username and password.

How is it possible to copy the database, without having the hosting panel access?

View Replies!   View Related
Mysql Access Host Via Command Line Or Sql Query
how to add a mysql access host by command line? or or how to add a mysql access host through an sql query?

View Replies!   View Related
How To Protect MySQL Database From My SQL Injection Attacks
some body attacking on my server and changing my users profile name /password or any other information so How To Protect MySQL Database From My SQL Injection Attacks? i have dedicate server i provide free wap sites to people with wildcard dns system and i have ConfigServer Security & Firewall installed.

View Replies!   View Related
How To Import Mysql Dump File To Database By SSH
How to import mysql dump file to database by SSH?

How to import mysql database host to other host database by SSH?

View Replies!   View Related
Move Mysql Database To Antoher Client(same Server)
how to do this in myphpadmin

also got cpanel if it helps.

View Replies!   View Related
Trying To Import Mysql Database Via CLI In Ubuntu Linux
I have ubuntu 6 server version running.

I am trying to import a database I have however I cannot get it working for the last 2 hours!

I have tried various commands like logging into mysql entering the "use" command to use a database and then variations of the "source" command but my db.sql file doesn't run.

Also tried the full command

mysql -uroot -pMYPASS MYDBNAME < /var/www/site/db.sql

Neither seem to do anything.

PHPMYADMIN shows no database tables at all.

Running mySQL 5.

View Replies!   View Related
Joomla Installation - Username/Password Incorrect MySQL Database Error
I am trying to install Joomla on httpme.com but I seem to have problems with it recognising the username/password. Could it be a localhost issue or something?

I just can't seem to get a solution to this. I am referring to step 1 of the Joomla installation.

View Replies!   View Related
Copy An Account From Another Server Via WHM - Cannot Copy Mysql Database
In previous thread we made few manual transfer of our domains.

We also made some automated migration of few domains/sites using Web Host Manager's Copy an account from another server feature.

All the files and other settings were properly transferred from old server to new server, but only the mysql database is not visible on new server. I am unsure if the same got copied to new server.

View Replies!   View Related
MYSQL Error "Could Not Connect To The Database"
Last night i went to install GD on my server(Linux RH) I went through the process /scripts/easyapache and at the end of it gave me this error

"...Unable to connect to host: 127.0.0.1......Failed......Unable to connect to
host: 127.0.0.1......Fail
ed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect
to host: 127.0.0.1.....
.Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to
connect to host: 127.0.0.1
......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable
to connect to host: 127.
0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed......Unable to connect to
host: 127.0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed...
The was no content, the test may be unable to connect to 8080 simply because
tomcat is still initila
izing.
You can try to go to
http://localhost:8080/
to manually check it.
-- End test 'Basic tomcat port running test' --
Post check of 'httpd' process Ok
-- End post apache restart tests --
Executing '/scripts/initfpsuexec'
Executing '/scripts/initsslhttpd'
Executing '/scripts/gentomcatlist2'
Compiling report...
Sending report (336 bytes)...
If you want to create a support ticket with cPanel regarding this please
reference 'BuildAP Report
Id': '528932'
Report processed.

You can change how PHP is configured.
As root, simply execute:
/usr/local/cpanel/bin/rebuild_phpconf --help
for more information.

Build Complete
Verbose logfile is at '/usr/local/cpanel/logs/easy/apache/build.1198389830'

Now I am unable to connect to MYSQL databases, MYSQL is still running from what I can see. I have base knowlage of Linux as well.

View Replies!   View Related
Command To Stop The Wget Command
Is there a command i can type into the ssh console to stop a current transfer that i started wit the wget command?

the file im wgeting always stuffs up at 51% but then the server just retries and starts again, its done it 3 times so far and i just want to completely cancle the process if possible....

View Replies!   View Related
How To Merge A Database Into A New Empty Database
How to merge a database into a new empty database?

I used this method and its not working
mysqldump --opt -uusername -p databasename > databasename.sql

mysqldump --opt -uusername -p databasename < databasename.sql
but get this error

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved