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 Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Mysql Files To .sql Query
I have the files .myd .myi and .frm files in a archive .tar.gz My host do not provide shell access. Is the any way that i can convert the files into .sql queries Or is there any method other that using shell access. Or is there any software to convert the database files into .sql query in my desktop computer so that i can restore it using phpmyadmin My site has been down from several days
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
Mysql And Ms Sql Host
I am trying to find a reliable host that can provide both mysql and ms sql for the same site. I know this is not how the site should be designed, and a complete redesign is in the works to streamline everything to mysql, but for now I need a host that can provide both. Our current host is absolutely horrible (seekdotnet.com) as there is an excessive amount of downtime (typically a few times/day for various periods of time). Thus far the only one I have been able to find is Mosso, but it seems a lot of people on here are anti-mosso, or have had problems with mosso.
View Replies!
View Related
Zip From Command Line
Im trying to zip up an sqlite database backup. I execute this command Code: zip ../d/db/backup.zip ../d/db/09-02-15.sqlite backup.zip never appears. Instead, I get some random filename in the directory. Like ziOHokOw If I try to zip a smaller file(last weeks backup) everything runs fine? Code: zip ../d/db/backup.zip ../d/db/09-02-08.sqlite So the 134mb file zips fine, but the 200mb one seems like its failing and im left with some type of temporary file. I tried downloading the weird filename and unzipping it. It has partial info like directory structure, the filename but the actual file inside is corrupt.
View Replies!
View Related
Ip Adjustment Via Command Line
Got a centos / cpanel box. Had to change the block of IP's with an entirely new block of 8. Problem is I cannot access cpanel/whm due to this, but only via ssh. If I run the below, it shows the old IP's /etc/init.d/ipaliases start How do I replace the old block with the new? I've never done it via command line before.
View Replies!
View Related
Command Line On Shared Hosting
I have been looking around for a new shared host, I am currently with GoDaddy =( And it would be helpful to have command line access for some things I am trying to do. Particularly with Zend Gdata API (which GoDaddy has trouble with anyway) Is this reasonable to ask for? I also need at least 150GB/month bandwidth for some relatively high quality streaming video.
View Replies!
View Related
Website Backup Over Command Line
We have a dedicated server, with chroot access enabled. We are wanting to backup each site on this server, as well as all mysql dbs on a weekly basis. Is it possible for us to run a cron job to do this? If so, what commands would we want to use? We have a local FTP server here, so would like to ftp these backups this machine. I know it all sounds a little vague, but I just need to know where to get started.
View Replies!
View Related
How To Detect Raid Harddisk Specs From Command Line
how can i remotly( SSH) figure out what kind of raid controller is on my system?! and how many harddisks my system has and what size?! I am working on Linux( Centos4) if i do #df -h then i get 146 G so if my system has raid1, does it mean that the harddisk is 2 X 146 G? or i should actually see it as 146 / 2?
View Replies!
View Related
Live Traffic View By VPS (or IP) Via Command Line
Back in the day, there was a commandline version of 'ntop' allowing a view of live traffic stats in the format of 'top'. Does a similar tool exist today effectively allowing us to figure our which VPS or IP address is under DDoS attack? The only way I could fix this was via KVM access to netstat -an | grep etc... Not too
View Replies!
View Related
BackupPC Restoring Files Without GUI Or Command Line
I got our server staff to install BackupPC on our dedicated server and run daily backups. All is well (from what I can tell) but i've come to a point where I want to actually use an archived file. So I jump into my ftp client, navigate to the backup folder, and download the file. The problem is, the file reads as jibberish. I'm assuming that BackupPC has compressed it. So the question is two-fold: 1. How do I decompress it on windows (command line stuff is well beyond me) 2. Is there any browser/windows apps that I can use to manage the backups?
View Replies!
View Related
Clear A Specific Email Account In Cpanel Or A Command Line Way
I just recently logged into my user email account "the one which was created by the name of the user of the account" and found it had 8000 emails but none are showing up in either horde or squirrelmail. How can i delete all these emails without deleting the other bla@domain.com emails? Is there a way just to clear a specific email account in cpanel or a command line way. I think if i just delete the mail folder it would kill all the emails of that account and I just want to 'reset' that one.
View Replies!
View Related
SSH Command ( Sql Backup)
I want to transfer a huge database (sql ) of 5 GB to other server ( Remote ) , but i do not know how to do it ! and later i want to restore it also on the 1st server after i format it! I know how to backup on my own server by using Quote: mysqldump -q -uxyourdomain -p -hmysql.yourdomain.com xyourdomain_2 >./myfile.txt But please help me in telling a command which can make MySql backup from DB to another server and a command which can restore MySql backup of DB to another server
View Replies!
View Related
Mysql Licensing Query
Our local authority is looking into using MySQL database for some internal applications and possibly our website. Do we need a commercial or enterprise license for this particular use or can we use a free version?
View Replies!
View Related
Mysql And Query Cache
What is the good value to set query_cache_size. I have set it to 60 M and here is the status. Is it good? I am not sure how to check this? Can anyone explain? query_cache_size=60M mysql> SHOW STATUS LIKE 'Qcache%'; +-------------------------+----------+ | Variable_name | Value | +-------------------------+----------+ | Qcache_free_blocks | 5 | | Qcache_free_memory | 62666440 | | Qcache_hits | 922 | | Qcache_inserts | 381 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 565 | | Qcache_queries_in_cache | 182 | | Qcache_total_blocks | 400 | +-------------------------+----------+ 8 rows in set (0.00 sec)
View Replies!
View Related
ERROR 1044 (42000) At Line 15: Access Denied For User
My server is new from SoftLayer when i try to restore Data Base He Give Me this Massege ERROR 1044 (42000) at line 15: Access denied for user 'mov_uu'@'localhost' to database 'mav2' i try to restore another data base he give Also A masseges ERROR 1064 (42000) at line 1: 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 And i have Upload Center It Was Work 100% Suddenly He give me Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request ------------------ also Warning: Unknown: failed to open stream: Permission denied in Unknown on line 0 Fatal error: Unknown: Failed opening required '/home/nameofuser/public_html/vb/index.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in Unknown on line 0
View Replies!
View Related
Lost Connection To Mysql Server During Query
some vBulletin customers facing to that error message, with session table with attachment only. Other just work fine. It's not because of server load. The load is just around 0 - 0.1 I have increased wait_timeout to 200 and max_allowed_packet to 64MB. Each attachment file in those vBulletin is just around 1-3MB. Is there any idea why and how to fix?
View Replies!
View Related
Very Slow Query Time After Upgrade To Mysql 5
We have a dedicated server and we host 4 news portals based on e107 and joomla. My partner on Sunday has upgraded mysql from version 4 to 5. Now the server experiences very high CPU usage and query time on portals has been increased very much. We used to have query times lower than 1 sec for the main page of [url](which is a site that receives about 2000 visits/day) and now query times are 5-15sec ! Does anybody know if this is makes sense ? Below is the server Status from WHM : ------------------------------------- cpdavd up cpsrvd up exim (exim-4.69-15.1_cpanel_maildir) up ftpd up httpd (2.2.11 (Unix)) up imap up interval up mysql (5.0.67-community-log) up named (9.3.4) up pop up rsyslogd up spamd up syslogd up Server Load 6.97 (1 cpu) Memory Used 49.4 % Swap Used 0.23 % Disk /dev/hda3 (/tmp) DMA+ 70 % Disk /dev/hda5 (/) DMA+ 22 % Disk /dev/hda1 (/boot) DMA+ 14 % Below is the Server Information from WHM : ------------------------------------------ Processor #1 Vendor: GenuineIntel Processor #1 Name: Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz Processor #1 speed: 2394.068 MHz Processor #1 cache size: 2048 KB Memory Information Memory: 2064420k/2087424k available (2091k kernel code, 21752k reserved, 846k data, 236k init, 1169920k highmem) System Information Linux server.aktoweb.biz 2.6.20-1.2319.fc5 #1 Mon May 21 19:52:13 EDT 2007 i686 i686 i386 GNU/Linux Physical Disks hda: WDC WD3200AAJB-00TYA0, ATA DISK drive hda: hw_config=600d hda: hw_config=600d hda: max request size: 512KiB hda: 625142448 sectors (320072 MB) w/8192KiB Cache, CHS=38913/255/63<6>hda: hw_config=600d hda: cache flushes supported Current Memory Usage total used free shared buffers cached Mem: 2066428 1756324 310104 0 339576 486636 -/+ buffers/cache: 930112 1136316 Swap: 1052248 2428 1049820 Total: 3118676 1758752 1359924 Current Disk Usage Filesystem Size Used Avail Use% Mounted on /dev/hda5 288G 60G 213G 22% / /dev/hda1 99M 13M 82M 14% /boot tmpfs 1009M 0 1009M 0% /dev/shm /dev/hda3 494M 215M 254M 46% /tmp Below is the CPU/Memmory/Mysql Usage from WHM : ------------------------------------------------- mysql42.707.300.0 Top Process%CPU 42.7/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking Top Process%CPU 42.6/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking giaprakigiapraki.com2.7012.111.7 Top Process%CPU 1.3httpd [urll] [/e107_plugins/pm/pm.php?inbox] Top Process%CPU 1.1httpd [url] [/e107_plugins/forum/forum_viewforum.php?87] Top Process%CPU 1.0httpd [url] [/e107_plugins/chatbox_menu/chatbox_iframe.php] adsnetadsnet.gr1.177.900.7 Top Process%CPU 0.5httpd [adsnet.gr] [/www/delivery/lg.php?bannerid16&campaignid4&zoneid5&chan] Top Process%CPU 0.4httpd [adsnet.gr] [/www/delivery/lg.php?bannerid50&campaignid6&zoneid15&cha] Top Process%CPU 0.3httpd [adsnet.gr] [/www/delivery/lg.php?bannerid183&campaignid77&zoneid1&ch] r40r40.gr1.073.340.0 Top Process%CPU 1.1httpd [r40.gr] [/index.php?optioncom_fireboard&Itemid188&funcshowcat&cat] Top Process%CPU 0.5httpd [r40.gr] [/images/fbfiles/avatars/s_64.png] Top Process%CPU 0.3httpd [r40.gr] [/index2.php?optioncom_jim&taskxml&no_html1] root0.278.532.0 Top Process%CPU 0.2[kjournald] alex123alexandroupoli.net0.030.270.0 Top Process%CPU 0.1httpd [alexandroupoli.net] [/e107_images/banners/banner468x60-alexandroupolinet.gif] galfasgalfas.gr0.030.270.0 Top Process%CPU 0.1httpd [galfas.gr] [/racing/images/galfas_R40_banner.jpg] eximstats0.000.000.3 nobody0.001.100.0 mailnull0.000.000.0 unauthenticated0.000.000.0 named0.000.10
View Replies!
View Related
ERROR 1044 (42000) At Line 21: Access Denied For User 'umar_cs'@'localhost' To Data
in ssh i try create new database root@server1 [~]# mysql -uumar_cs -ppassword umar_cs </home/umar/public_html/localhost.sql it is show direct ERROR 1044 (42000) at line 21: Access denied for user 'umar_cs'@'localhost' to database 'umar_cs' i try from script same message i think maybe the problem from the size in this file /etc/my.conf set-variable = max_connections=500 i change to set-variable = max_connections=500M and restart mysql and i try create same problem!
View Replies!
View Related
MySQL Query Doing Odd Things - Removing Negative Sign For No Apparant Reason
I've got a problem with an SQL query that is behaving badly. Its probably really obvious, but I can't see the problem! I have a table with 3 fields: Code: money bigint(20) income int(12) userID mediumint(7) I have a row that has a negative money and a value of 0 for income. When I update the money value to add "0" to it, nothing happens (as expected). When I update the money field to add the income field (which is equal to 0) to it, MySQL flips the sign to make the money field positive. The following queries show the problem: Code: mysql> SELECT money, income from users where userID=327961; +----------------------+--------+ | money | income | +----------------------+--------+ | -9223372036854775807 | 0 | +----------------------+--------+ 1 row in set (0.00 sec) mysql> UPDATE `users` SET money = money + 0 WHERE userID =327961; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 mysql> SELECT money, income from users where userID=327961; +----------------------+--------+ | money | income | +----------------------+--------+ | -9223372036854775807 | 0 | +----------------------+--------+ 1 row in set (0.00 sec) mysql> UPDATE `users` SET money = money + income WHERE userID =327961; Query OK, 1 row affected, 1 warning (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 1 mysql> SELECT money, income from users where userID=327961; +---------------------+--------+ | money | income | +---------------------+--------+ | 9223372036854775807 | 0 | +---------------------+--------+ 1 row in set (0.00 sec) mysql> Notice that there is no negative sign after the third select!! So, we are saying that executing an update where 0 is specified in the query results in the correct action but if you take the 0 from another field it takes the negative sign away... This for various reasons is a rather urgent problem. This problem has only appeared after upgrading from MySQL 4.0 to MySQl 5.1. This problem does not occur in MySQL 4.1.
View Replies!
View Related
Sql Db Move To New Host
I just moved a website I took over to a new host. The programmer hard-coded the DB in. The old code refers to the mediatemple address: mysql_connect("internal-db.s5363.gridserver.com", "db5363", "-removed-") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db("db5363_bb", $link) how I can configure this for the new (CPanel) IGX Host server?
View Replies!
View Related
Remote / Off Host SQL
I've seen this mentioned before, that you can run SQL on a separate server and lot of people do it for SQL heavy applications. Only thing I wonder, how well does it work bandwidth wise? Is there a noticeable slowdown in query speed? What about bandwidth cost, does it use a lot, enough to run over a typical dedicated server monthly limit? Also what about security, are queries/username/password sent out in clear text?
View Replies!
View Related
Windows/sql Host
Can anyone recommend a windows based host that I can have one account with up to 5 (prefer 10) sites on. Potentially each site might need a small database. Is the best route to go down a VPS? Can anyone recommend a host. Ideally it needs to be under $40 pcm to start with.
View Replies!
View Related
How Can I Import .sql Form Mysql 4.1 To 4.0
i am not sure if this is the right sub-forum to post the question. it is that i my a forum running with php and mysql, the version of it is 4.1 now, i wnat to move the forum to another server, but the mysql version of the server is 4.0, i try to backup the .sql form phpmyadmin and import form phpmyadmin,too. but it failed, some article tell me that i should change some setting in the .sql file, but i try and failed, can anyone teach me how can i process it?
View Replies!
View Related
Where To Host A Powerful SQL Server
I have a project coming up to host a self developed database app on a web based SQL server. We have received the prepayment for the server rent for 24 months already and are currently looking for the best possible provider. Requirements: Uptime and service response is critical for us. We want an unmanaged server but require the best possible response time in case of hardware defects or network issues (DDoS). In the beginning the user base (small) will mainly be in Europe but with the tendency to grow more continents. I’d like a US east cost location with a speedy connect to EU but would consider an EU provider with a good rep. Server specs: I7 processor for fast RAM access 12GB DDR3 RAM (probably more later) 2 x SSD 80GB in Raid 1 (planning to go RAID10 on 4 disks later) Hardware Raid controller 2 TB traffic /month Windows Server Std 2003 x64 SQL Server 2008 Unmanaged. No help needed with server config. We intend to keep the same hardware for 24 months. So rent to own might be an option Large upfront payment are ok to reduce monthly costs. Hardware SLA would be nice KVMoIP would be nice Firewall: Dedicated unit would be nice but we have no experience here and would need full support.
View Replies!
View Related
Very Reliable Windows Host With MS SQL
im in the market for a very reliable shared hosting windows host. It i s crucial for us to have maximum amount of uptime. storage and bandwidth needed is not very much about 40-50 gigs maximum per month. It is also important that we are able to add "alias" domains or "pointer" domains to go to the same place. Price is not really a concern. I was looking at the 1and1 windows hosting package but im afraid i wont get any support if ever I have any problems.
View Replies!
View Related
Asp.net Sql 2005 Host
I am in search of windows host supporting .net 2.0 and sql 2005 and atleast 2 domains (3 will be good). I need around 3 gb space and 20gb bandwidth is enough. My maximum I have checked the offers section and other posts here and below are the shortlisted hosts: discountasp eukhosts appliedi exabytes Can someone who's using them give a suggestion/feedback or else can suggest one?
View Replies!
View Related
Host With Max Concurrent SQL Connections
Iam currently on godaddy on shared hosting but my site with php and mysql is very slow on queries and get a lot of timeouts So far i have contacted the below providers and asked them how many concurrent connections on mysql database they support hostgator - 25 connections powweb - 20 connections hostmonster - 30 connections Servage - 20 connections anhosting - 50 connections How is most reliable and i can count on ? I want to tranfer my domain.
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
MySQL DB Access Allowed? Are There Any?
For window hosting are there any that offers sql db external access without ip limit? I've seriously requested thought the forums and actually signed up with few but all of em are either offered it but not anymore(security issue) or not even offering at all. If you have any experience with hosting company that actually does offer sql db external access please share please! vps nor dedicated servers are not my choice unfortunatley and i don't think there's any free hosting that offers this. 99% freehostings use localhost
View Replies!
View Related
Mysql Access Denied
I've setup a mysql user and assigned a password for it. When I try logging in to it with Quote: mysql -u USERNAME -p and then providing the password I get an error: Quote: ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: YES) I don't have trouble logging in as root and when I check the user table there, the password assigned to the user is same as the value the mysql function PASSWORD gives me. Really driving me nuts here, why is it telling me the password is wrong when it's not? I've tried: Restarting mysql setting new password changing username Using mysql server 5.1.34
View Replies!
View Related
Mysql Account Access
I run a shared hosting OS:centos with whm/cpanel and would like to restrict access to mysql database example: username:user1 created database:user1_db1,user1_db2 etc.. and can only access his own databases so user2 can't access user1_db1.db2 etc.. and user1 can't access user2_db1,db2 etc..
View Replies!
View Related
Allow Remote Mysql Access
I have a Ubuntu Lamp server setup in my building which is used for development purposes. So I also have phpmyadmin setup and am using a Mysql Query browser and Mysql Administrator desktop programs to administor the database on the server. However I am not able to connect to the server from my desktop. I am able to login to my myphpadmin but not able to login via the Mysql Query Browser program. Hopwing someone can help. I have read about port forwarding and also read a post about editing the my.cnf file on the server and changing the Bind-Address= 127.0.0.1 to the actual hostname but before I start editing the actual configuration files on the server I want to see if their is another way as I am worried that if I change the me.conf file that the phpmyadmin may stop working?
View Replies!
View Related
Can't Access My Site Or My Host
I woke up this morning to find I wasn't able to access my domain based email or my website. So I figured I would check with my host, (www.hostpc.com), and I was unable to access them, also. I had someone else from a remote location and PC check and they can access hostpc as well as my website. My PC is up and running fine otherwise.
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
|
TRACKER
