0
votes
0answers
16 views

Analyze a Database to Find Failed Foreign Key Constraints [migrated]

I aggressively deleted a ton of data after using this query: SET FOREIGN_KEY_CHECKS = 0; Is there any easy way I can analyze the entire database to check to see if I have any hanging records that ...
0
votes
1answer
66 views

CentOS 5.8 - The most difficult MySQL installation ever?

To install I did: yum --enablerepo=remi,remi-test install mysql mysql-server Result of the last 3 lines: Installed: mysql-server.x86_64 0:5.0.95-5.el5_9 Complete! Then I did the following: ...
0
votes
1answer
36 views

How to execute multiple SQL statements in virtualmin / mysql

Using the "Execute SQL" feature of the mysql addin for virtualmin, what is the syntax for executing multiple statements? For example if I want to do: delete from Table1; delete from Table2; I get ...
0
votes
2answers
42 views

Ubuntu 10.04 database connection problems

I'm having some problems with a legacy program I'm starting back up. We had an image of this server, and the setup is Ubuntu 10.04, 5gb partition for mysql database, and 100gb filesystem. My issue ...
0
votes
0answers
30 views

MySQL: copy column error: “Unknown column 'dbname.tablename.columnA' in 'field list'”

Wanting to copy the contents of one column in a table from one db to another db I found an answer on S.O. here; the second answer by slaakso (I didn't understand how to use the first answer) When I ...
0
votes
1answer
39 views

MySQL reclaim index space after large delete?

After performing a large delete in MySQL, I understand you need to run a NULL ALTER to reclaim disk space, is this also true for reclaiming index space? We have tables using > 10G of index space and ...
1
vote
3answers
89 views

MySQL high cpu load slow quries being logged need help to understand

I'm trying to troubleshoot a high load problem on a server, Today for some reason MySQL is taking up excessive CPU time. I have enabled slow-queries and found this query and others similar. The ...
0
votes
0answers
30 views

Best way to export / import an older mediawiki setup

I have a client who needs to export an entire setup for mediawiki (images/site/extensions/database/ect) so I can literally take the exported version, copy it into my htdocs (or www/ folder), import ...
1
vote
1answer
338 views

centos mysql keeps crashing, what to do?

I recently got a dedicated server under CentOS with OVH. Everything has been working fine since 2 months, but starting a few days ago mysql keeps crashing and that causes various problems with my ...
1
vote
1answer
71 views

Importing old mediawiki SQL dump MAMP

I've been tasked with importing an SQL database to setup up with a local mediawiki website (v1.14). We were sent a SQL file with an image file to upload to the local site. After setting up mediawiki ...
0
votes
1answer
55 views

Grant user Permission using Wild Card on MYSQL

I'd like to Grant for example an insert permission for spacific user in all databases started by WA_ for example in my server I make the following syntax but it dosent work GRANT SELECT ON ...
0
votes
3answers
52 views

Connecting mySQL to MSSQL

I need a little advise, I need to sync a DB that is currently on a Server 2008(SQL Server 2005) machine and I use Studio Express to connect to it. I need a way of syncing this DB to mysql that lives ...
0
votes
1answer
46 views

MySQL replication as both master and slave (replication loop?)

I've got two MySQL servers, one as a master in the replication process and the other as the slave. I was wondering if anything bad would happen if I made the current master a slave to the current ...
0
votes
2answers
43 views

Export import sql database without downloading

Recently i need to change my server to another webhosting providers server. To do that just discovered that my MySQL database size is too much to download & upload with the access that I have. ...
0
votes
1answer
477 views

User upgraded to SQL Connector 6.6.5 now gets: Authentication with old password no longer supported, use 4.1 style passwords

I have a dev user who is running queries to bugzilla via .NET code, and after updating his connector gets the error "Authentication with old password no longer supported, use 4.1 style passwords." I ...
1
vote
1answer
424 views

Enable MySQL to use more than 1 core (multicore)

I am running a very intensive MySQL query and noticed that only 1 core is being used to 100% while the other cores are idle. The system is running Ubuntu 12.04 and MySQL 5.5.28 Is there a way to ...
0
votes
0answers
1k views

phpMyAdmin gives #1040 Cannot log in to the MySQL server error after a few weeks

I am running MySQL and phpMyAdmin (under Apache) on a CentOS VPS, everything works fine, but after a few weeks services using the database start having issues and all users except for root get the ...
0
votes
2answers
98 views

Coverting MySQL SQL statements to SQL Server

I am installing a product which needs a database - it can use any database as long as there is a jdbc connector available for it. However, the installation guide has instructions only on how to make ...
4
votes
1answer
262 views

Ran out of disk space, how to tar without creating copy

I am at 98% of an 8GB SSD, and I have a 3 GB mysql data that I need to gzip and or tar and then download it, so then I can delete it. How can I tar or gzip the sql (or the mysql tables) so that that ...
1
vote
2answers
146 views

Group By , COUNT(*) and JOIN

When running the SQL below, any placemark_types.id that doesn't have a id match in placemarks table does not return anything in the results. I'm trying to at least get a type_count of 0 back where ...
0
votes
3answers
328 views

How to update phpmyadmin on hosted website? [closed]

I have a personal home page and I decided to start a server. I use ipage.com and their phpmyadmin is an old version. How to update to the newest 3rd version? I've read documentations and the problem ...
1
vote
5answers
1k views

Mysql - drop database with # in name

How can i delete database with # in name? Like that: #mysql50#mysql.backup I don't know who is possible to created it, but it happened. When I try DROP DATABASE name, I have error: ERROR 1102 ...
0
votes
2answers
247 views

How can I move a MySQL database to a new localhost? [closed]

I have a localhost (XAMPP) on an old pc. I need the MySQL database on my new mac with a localhost (MAMP). Issue is, pc doesn't have internet connection. Any way I can move the database over? Detailed ...
0
votes
0answers
32 views

WP RECOVERY unable to link DB to WP 'Error establishing a database connection'

I have the following error. Error establishing a database connection I have a WP +BP + Faecbook site that is down. I had a recent backup before I made the changes. I am tryng to restore that. I ...
0
votes
1answer
79 views

MySQL broke; how can I save some of the tables?

For some reason my MySQL can't connect any more. I'm running three WordPress sites and I need to save the tables. That's what I really really really really care about. Here is the problem: ...
-1
votes
2answers
219 views

The good SQL database to process a lot of data?

I have to process like 10-100 millions records. I have to give the data to the client when it's finish. The data is givent as SQL requests to execute in the database. He have a powerful server with ...
0
votes
3answers
122 views

How to link mysql query to a php process?

I noticed I have an abnormally large amount of mysqld processes which have various mysql queries; I've restarted mysqld and all of these processes come back within 10 seconds. I know the processes ...
0
votes
1answer
91 views

Error 1045 while configuring mysql

I can install the mysql but while configuring it i am getting error like this: ** 1045 : access denied for user root@loaclhost.** i can install it i cant configure it. Please help...I am quite new to ...
0
votes
2answers
718 views

SQL query to Automatically Export to file and FTP?

I am wondering if there is such a way to automatically run SQL queries and export to file (example: csv file) and then FTP to desired location? It seems simple and would need something like this as it ...
0
votes
2answers
144 views

After system reboot can't connect to mysql

in order to be able to use a jquery plugin to upload files i had to increase some variables from php.ini, so i had to reboot, I used the webmin option to reboot system, now it seems that the ...
3
votes
5answers
464 views

MySQL query, 2 similar servers, 2 minute difference in execution times

I had a similar question on stack overflow, but it seems to be more server/mysql setup related than coding. The queries below all execute instantly on our development server where as they can take ...
0
votes
3answers
383 views

What database server will benefit from 4 CPUs

I use MySQL server on Debian GNU/Linux machine with 4 CPUs (Linode 4096) and there are performace issue on havy load (in the middle of the day) but machine is not overload only queries are slow. What ...
0
votes
1answer
146 views

using command line to extract large db file

I have a large database file (1.5GB) named file.sql, I use "source" command to extract it into mysql databse but I receive lots of error messages. It used to work fine. Here is a snapshot of part of ...
1
vote
2answers
132 views

downloading a large database

I tried to export a large sized database using phpmyadmin but later the downloaded file seems to be of incorrect size, many of the tables inside the database are eliminated during download. The file ...
0
votes
5answers
556 views

Move MySQL DB to another server

I have server with very big mysql database (160GB). How easy way to move this DB to another server?
-1
votes
1answer
144 views

Big SQL database platform that performs well [closed]

I would like to know your opinion on which DBMS (probably SQL) can perform fairly well and not stress the server too much from the CPU / RAM point of view. I'm used to MySQL but I found (maybe it was ...
2
votes
1answer
466 views

How to store text inputs of unknown & varying size? [closed]

I am trying to create a table (or several) to receive user inputs (UGC). This content could vary in size from a single character up to a few hundred words. The input will be coded in utf8_unicode_ci ...
0
votes
1answer
144 views

Setting up a dedicated mysql server

I got a dedicated VPS and installed mysql on it(I am new at this). Now from my web server(on a different server), when I make queries it takes 10x longer than it used to take to make the queries when ...
1
vote
1answer
435 views

MySQL - Changing FT_MIN_WORD_LEN (my.ini)

I've recently asked my server administrator, for my Windows dedicated server, to change the MySQL configuration file (my.cnf) to allow search words of 2 characters or more, from the default of 4. ...
1
vote
2answers
769 views

Cannot connect to a MySql Server using MySql Workbench with no apparent reason

I can't connect via TCP/IP to the MySQL server. The server is installed in a Debian Linux and there's a PostGreSQL server running at the same time. (which is working fine and has tcp/ip connection ...
-6
votes
2answers
95 views

Learning PostgreSQL after using MySQL [closed]

I'm looking for a simple resource for getting the hang of Postgres after using MySQL for years. So far I've figured out \l, \d, and \c, but I'm having trouble listing the tables in my MediaWiki ...
1
vote
2answers
310 views

Split large sql file by location of string OR start sql from last fail

I have a 15GB sql file which is a backup of a database. The problem I have is that half way through it, it failed. Luckily, I know which table to pick up from. Is there a way I can split this SQL ...
0
votes
1answer
117 views

How to recover MYSQL databases from a hard drive backup

I have recently had a problem with one of my VPS's and I do not have a recent backup of the MYSQL databases, although I have a full backup of /var. I have determined from the MYSQL config that the ...
1
vote
0answers
231 views

Error when using mysql to create or change users

I went to change passwword on my mysql user to make sure it was correct for wordpress and when i did it i got Failed to save user : SQL flush privileges failed : Table 'mysql.servers' doesn't exist so ...
0
votes
2answers
152 views

Any other configuration for MySQL database?

I'm trying to set up a MySQL database, and all seems to be working except I cannot get PHP files to communicate with it. Just to be clear, the PHP files are correct, along with the host name, ...
0
votes
2answers
533 views

Multiple mysql servers with one database?

What are the options for having multiple mysql servers with the same database and data. I know there is replication but I have been reading that it can have issues especially if there are connection ...
1
vote
1answer
56 views

How to make MySQL to find old databases on HDD?

I have reinstalled a MySQL 5.0instance to the same location (OS Windows XP), and afterwards, databases stored in /data/ folder become invisible by MySQL. How I can to make it visible again ? All ...
2
votes
1answer
580 views

Deleting MySQL rows causes lock table error

I had a couple million rows to delete but they can't be deleted at once without this error ERROR 1206 (HY000): The total number of locks exceeds the lock table size So I wrote a script to delete ...
0
votes
1answer
186 views

Running indexhibit with a non-MySQL backend — can it be done?

The version of the Indexhibit PHP-based CMS that's available for public download has been 0.70 (or thereabouts) for around four years, and as far as I know, it's been a MySQL-only app for the entirety ...
1
vote
2answers
291 views

Can't login to phpMyAdmin

I am unable to log into phpMyAdmin after installation. Here is my config.inc.php file. Am I doing something obviously wrong? I'm sorry, this is the first time I'm dealing with PHP, MySQL, etc. Thanks ...