It was recommended by my software vendor that I use MyISAM and stay away from InnoDB.
InnoDB is the default storage engine on my box, but I have no InnoDB's at this time.
Everything says MyISAM (in phpMyAdmin). Could I just reinstall SQL (with MyISAM) from scratch? Or will I need to backup and reload from dump?
What is more suitable for shared web hosting?
View 8 Replies View RelatedMySQL didn't work well on my server so I had a look at the err file. It indicates that MySQL is getting started and stopped all the time. After it has started it will stop and then start again etc:
070106 14:40:25 InnoDB: Started; log sequence number 5 959534492
/usr/sbin/mysqld: ready for connections.
Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Communi$
A mysqld process already exists at Sat Jan 6 14:40:28 CST 2007
070106 14:40:38 [Note] /usr/sbin/mysqld: Normal shutdown
070106 14:40:38 [ERROR] /usr/sbin/mysqld: Sort aborted
070106 14:40:40 InnoDB: Starting shutdown...
070106 14:40:41 InnoDB: Shutdown completed; log sequence number 5 959534492
070106 14:40:41 [Note] /usr/sbin/mysqld: Shutdown complete
070106 14:40:42 mysqld ended
070106 14:40:42 mysqld started
070106 14:40:42 InnoDB: Started; log sequence number 5 959534492
1. If I recompile my mysql, can that potentially harm any of my database / table / data?
2. Here is a list of files. [url]. I guess, I have the same in my server. Any idea how can I access to these files?
Here is what I got -
root@usr [/]# find myisam
find: myisam: No such file or directory
how to enable innodb
use this command in mysql ....
I finally found a shopping cart that I think will fit my needs. I registered a hosting account with Hostgator a couple months ago so that I'm now out of the refund period. It's great for my Wordpress site, but I got an error when I tried to install LiveCart. It said that I need InnoDB. I contacted Hostgator's support, and they said that they don't support InnoDB. Is that true? I don't want to have to move hosts and be out my year of hosting fees.
View 6 Replies View RelatedQuestion for people who have moved to InnoDB: I wonder if it is worthwhile?
I don't care about ACID compliance, my only interest is in the row level locking which I do not get with large MYISAM tables which do table locking and clog up everything. I have a huge database that needs frequent updates, like 50,000 per hour. I also don't care about InnoDB's large size of indexes and such, I have lots of hard disk to throw at it.
My fear is with the backup of InnoDB tables, and the fact that it is not as simple to "fire up" the tables when I restart the database. MySQL manual suggests something like a query to "Warm up" the tables.
Any thoughts would be great, and if possible, any help with what settings you use. FYI, I am on a 4GB RAM machine with dual Core2Duo procs. When I tried the following in my.cnf for the InnoDB stuff ---
Code:
#skip-innodb
innodb_buffer_pool_size=1G
# Set the log file size to about 25% of the buffer pool size
innodb_log_file_size=250M
innodb_log_buffer_size=8M
innodb_data_file_path=/idbdata1:200M:autoextend
innodb_additional_mem_pool_size=20M
innodb_log_group_home_dir = /iblogs
innodb_log_files_in_group = 2
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=10
--- the MySQLD wouldn't start! Question about the stuff in red: what're those paths for?
Do I need to create those paths?
I'm getting ready to setup a dedicated server for a site that is database intensive that mostly uses mysql innodb databases.
What is the best setup for me that would allow regular database backups of my innodb databases the easiest way possible. I basically want to be able to backup my database at a regular interval (probably weekly) without having to think too much (and without having to shut down my server each time or stop my database).
I'm not too tech savvy with database management so am after tips on:
- Best server setup (second drive just for bakups?)
- I Don't fully understand RAID 1 setups and how they would benefit me
- Explain to me the backup process for any solution you suggest
I've been with my Strato VServer and it installed Plesk on Linux a big problem.
I coming no longer in the Plesk Dashboard and the following code appears:
Syntax error or access violation: 1286 Unknown table engine 'InnoDB'
Here are the contents of my my.cnf
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
[Code] .....
I am using Parallels Plesk Panel v. 11.0.9 on a V-Server provided by Strato (Germany), the OS is Ubuntu 10.04 LTS. Established and running under Plesk is a MySQL-Database, administered via Plesk by PHPMyAdmin 3.5.8.1. PHPMyAdmin offers the following information:
Datenbank-Server
Server: Localhost via UNIX socket
Software: MySQL
Software-Version: 5.1.41-3ubuntu12.10 - (Ubuntu)
Protokoll-Version: 10
Benutzer: admin@localhost
Server Zeichensatz: UTF-8 Unicode (utf8)
Webserver
sw-cp-server
Datenbank-Client Version: libmysql - mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $
PHP-Erweiterung: mysql
Click to expand...
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies View RelatedI recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
Can someone recommended me some one with knowledge of mysql exploit or mysql injection, it seem to our VB forum have issue with database load..
View 5 Replies View RelatedI've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.
Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.
The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).
The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.
Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
my /var partition is full,
im not sure if any files i can remove to get more free space on /var partition.
because there are more free space on /home,
i think if i can move all the /var/lib/mysql to /home/mysql,
if yes,howcan i move it and do any change,
can let the sql data do not lose,
andrun well in the feature ?
I've rented a dedicated server that comes with Red Hat Enterprise Linux 4 and MySQL 3.23 but I need at least MySQL 4.1 or higher. My knowledge about GNU/Linux is very limited, so I've read some documents at mysql.com and now I think I have to follow these steps:
1. Uninstall MySQL 3.23 with this command line:
shell> rpm -e mysql-*.rpm
2. Install the server and client RPMs of MySQL 5.0:
shell> rpm -i MySQL-server-VERSION.i386.rpm
shell> rpm -i MySQL-client-VERSION.i386.rpm
I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues?
View 6 Replies View Related