Hello I'm using jQuery .ajax function to load php page with a mysql query in it that selects data from the database, but my question is: Does refreshing mysql query by jQuery ajax crashs or tiring the database? Info: Refreshing by 1 second using setInterval(). Edited: This the queries that I use to refresh them. SELECT * FROM table1 ...
Hey, I'm using derby for development in eclipse. Is it possible to dump a table from MySQL and use it for derby in some way? I know that ddl & dml are different for both dbms but I'm looking for a way, other than dump/export, that would be appropriate. ...
I am doing the following, and getting "1" which I assume means the statement wend well. But I would like the result instead. What's wrong? #!/usr/bin/perl use strict; use DBI; my $host = "test"; my $database = "dd"; my $port = 3306; my $user = "uuu"; my $pw = "ppp"; my $mysql = DBI->connect("DBI:mysql:database=$database;host=$host;p...
Hello, I am attempting to convert a ISO8859-1 string taken from a MySQL database and convert it to UTF-8 using php. However, when I use the utf8_encode function it removes almost all of the apostrophes from the string (the exceptions seem to be within html fields). Thanks ...
Please, write 1 example config connect database from localhost to godaddy. This is connect to database from files on server to server : var $default = array( 'driver' => 'mysql', 'persistent' => false, 'host' => 'mysite.db.6650008.hostedresource.com', 'login' => 'myaccount', 'password' => 'password12', 'database' => 'mysit...
I have just moved the web application into a new web server and new DB server. With the latest version of everything. However, when I run the application in live (with over 1000 users), I observe that every 2-3 minutes, there are slow query report. And when this happened, the php processes ( use 'top') shrink from 30 processes to a fe...
I have the following tables: platforms(id,platformname) games(id,title,platformid) gameslists(id,memberid,gameid) I would like to select all records from the games table, but exclude records where games.gameid is present in gameslists for a specific member. So in plain English: select all records from the games table except for those ...
If I were to translate my MySQL table into PHP it might look something like this: $table = array(); $table[0] = array ('id'=>0, 'f1'=>0, 'f2'=>1); $table[1] = array ('id'=>1, 'f1'=>0, 'f2'=>2); // etc... In that case, I would want to do something like this: foreach($table as $row) { $row['f1'] = $row['f2']; } Is it possible to ...
hello All im upgrading from mysql 4.x to 5 version. in my php source i have following source which working well on mysql 4.x version. but if on mysql 5.x version, it not working. i think following part of my php source some suspect which cause some problem. if anyone help me much appreate <? include('_connect_site_01.php');...
I have a MySQL table "stats", which is a list of entries for each login into a website. Each entry has a "userId" string, a "loginTime" timestamp and other fields. There can be more than one entry for each user - one for each login that he makes. I want to write a query that will calculate the average of unique daily logins over, say, 30...
Hi, I have 2 databases with MyISAM tables which are updated once a week. They are quite big in size (one DB is 2GB and the other is 6GB). I currently back them up once a week with mysqldump and keep the last 2 weeks' worth of .sql dumps on the same server where the DBs are running. I would like, however, to be able to dump the backups ...
Hello, My website stores several million entities. Visitors search for entities by typing words contained only in the titles. The titles are at most 100 characters long. This is not a case of classic document search, where users search inside large blobs. The fields are very short. Also, the main issue here is performance (and not r...
Hi there! I have installed MySQL server enterprise 5.1 on my local machine and now I want to install phpMyAdmin.. but it does not work. I have unrared phpMyAdmin to my server root directory and browsed to "localhost/phpMyAdmin/setup/index.php", started a new server and the only setting I changed was filling in my MySQL password in the ...
Hi guys, I am creating a form that will capture all of the form data and store it in a database, what I would like to do is use some of the form data to create a custom md5 user id to prevent multiple entries, I know that this is most probably not the most ideal way of doing it, so if there is a better way of creating a unique md5 uid ...
Im trying to restore my mysql db from the dumpfile i have created. This is my code: Shell(My.Application.Info.DirectoryPath & "\mysql.exe" & " --user=root --database testdb < " & """" & txtRestore.Text & """") But nothing is happening; data is not being restored in the db. Please help me in this! ...
Hi, i have something like 40K rows and i must run update query like this: UPDATE table1 SET column1='very long value 1...', column2='normal lenght value 1a' WHERE pid ='123' column3='ccc'; column1 is TEXT column2 is Varchar(150) ...and i want to use mysql query what is more server resource friendly. I want to use something lik...
Hi friends my database is CREATE TABLE `mytable` ( `id` int(10) AUTO_INCREMENT, `name` varchar(50), `description` varchar(255), `visible` varchar(10), PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET utf8; and php code is $display = query("SELECT * FROM mytable ORDER BY id ASC"); f...
I'm doing an inventory for a game, rather like a FF-style game. I have two design in mind, and wonder which is better Keep track of quantity as a field; the schema would be: item ( <item_id>, <character_id>, quantity ). If a character equip an item, or remove an item from his inventory, I would need to make sure the quantity field is c...
Which scripts/solutions do use for import and export large mysql databases? Phpmyadmin gives an error for these operations, if there is a big amount of data. ...
Hi, I've got two tables. I'm trying to calculating the SUM quantity of tbl1 tbl1.xid is the primary, while tbl2.xid is the foreign tbl1 xid pub quantity 1 1 10 2 1 2 3 0 1 4 1 5 tbl2 id ttype fno xid qnty 1 A 0 1 0 2 A 1 1 3 3 B 1 1 4 4 A ...