Currently viewing the tag: "MySQL"
Speaker: Muhaimin Dzulfakar Security Consultant, security-assessment.com This talk focuses on how MySQL SQL injection vulnerabilities can be used to gain remote code execution on the LAMP and WAMP environments. Attackers performing SQL injection on a MySQL platform must deal with several limitations and constraints. For example, the lack of multiple statements in one query makes MySQL an unpopular platform for remote code execution compared to other platforms. This talk will show that arbitrary code execution is possible on the MySQL platform and explain the techniques. In this presentation, the author will release a new tool titled MySqloit. This tool can be integrated with metasploit and is able to upload and execute shellcodes using a SQL Injection vulnerability in LAMP or WAMP environments. For more information visit: bit.ly To download the video visit: bit.ly
A continuation of the coffee cup form builder tutorial showing how to create a mysql database for a form. Making a MYSQL Database was created by Mike Lively Director of A&S Instructional Design at Northern Kentucky University NKU.
In this tutorial, you will learn how to turn your computer into your own private webserver by installing XAMPP. Besure to SUBSCRIBE because there will be a new tutorial every week. Follow me on Twitter @RiverCityGraphx Like us on on facebook: on.fb.me Suggest tutorials at www.rivercitygraphix.com For project files, help forums, and more check out the website at http For business related inquires contact us at rivercitygraphix@yahoo.com
Question: How do you create an automatic backup for database designed in MySQL?
i built a database using MySQL. Now my client wants to backup the database once every week and every month. How do i do it ? Where do i find the tool?
Answer:
Answer by thundercats
If this is under a *nix environment, run a cron job that does a mysqldump.
Question: Is searching a large MySQL database going to be a problem?
I just started exploring MySQL for a database that I want to set up. I want the online user to be able to search for any word in the entire database. The database might become 500 meg over time (small compared to facebook, big compared to a employee databse). At what point does searching that amount of a MySQL database going to be an issue? I am new to MySQL and databases, so any other help or suggestion regarding this topic is greatly appreciated.
Answer:
Answer by mti2935
Hi Robin, I work for a company that runs a mysql database that’s about 2.5GB in size. We have a few tables that have 10 million plus records. In general we have found that searches are very fast as long as the fields that we are searching on are indexed properly. I’ve worked with a number of other RDBMS’s including Oracle and MS SQL Server and in my opinion, mysql is very competitive across the board with the others and in many ways easier to manage, especially now with support for stored procedures in version 5. Hope this helps.
Question: How to display 2 different database having the same table format and record format using PHP Mysql?
2 database called Database2009 and Database2010, How to display both with same record in one line having the same ID Name, Address but different columns in Year2009 & Year2010 in one row as comparative report using PHP MySql….
Answer:
Answer by Melana
Hmm…. If I am right it is possible with frames, or not?
Question: How do to time controlled events in php and mySQL?
I’m working on making a browser based, turn based game as a way of teaching myself php and mySQL and to have a bit of fun in the process. Many of the games of this type have turns that regenerate over time. But I’m not sure how to code something like that.
What would be the best way to have data in a SQL table that changes over time regardless of whether someone is accessing the PHP page or not?
Answer:
Answer by Vladimir Kornea
You can’t make it change over time, but you don’t need to. You need to remember the last time it changed. The next time you need the data, compare the timestamp of the last change to the current timestamp, resolve any actions that should have happened in the interim, and update the database at that point (remembering to also update the timestamp).
If players may continue their game after a long absence, resolving all the actions since their last action may take a long time. To prevent this, schedule a script to run on a daily basis and resolve any outstanding actions at that point.
If the game is multiplayer, and the players’ moves affect each other, then you must resolve all the actions each turn. If you have access to cron, you can schedule a script to run every minute. If you need the script to run more frequently, cron will not help you. Instead, you can write a single script, remove its time limit so the server lets it run indefinitely, and have it fork each game turn, with the child resolving whatever actions need to be taken and then terminating, while the parent waits for the next game turn in order to fork again.
Question: What books/courses do you recommend to become MySQL certified?
I would like to become a certified expert in MySQL 5.0. I have seen some study books for MySQL certification on Amazon, but they are a few years old.
What books/courses do you recommend for becoming a certified MySQL DBA?
Answer:
Answer by joman
Hi,bluethundr,glad to answer your question
I know there are so many ways to help you and you can’t make sure what is the best,it seems as if most of them is useful for you,but i can sure not all of them can guarantee that you can pass the exam to be a one-time certificate.
However passcert can let you become a certified MySQL DBA earlier and faster and promise you get certification in the first attempt or they will give you a FULL REFUND
these are adress for you
http://www.passcert.com/005-002.html
http://www.passcert.com/006-002.html
If you have another doubt pls email me: liujoman@yahoo.com
Hope I can do something for you and the most important is that be your friend is my best pleasure
Question: How to overwrite / update a previous record automatically in mySQL?
I have a mysql database that receives the data from a php form that submits a unique user id, and 3 sports. I will likely be adding new fields (age etc) but the main thing I want to accomplish is if my users go through the form again (logged into to the same user id) and submit different information, how could I overwrite the old entry so I only have 1 record for the user?
hopefully this is possible one way or another !
Answer:
Answer by ?
use update…
“UPDATE usertable SET userid = 1234 WHERE userid = 4567″
This will update the row where userid is equal to 4567 to a new user id of 1234 on the table named “usertable”.
Question: Can someone teach me how to plot certain records to a desired map using php mysql?
Using php mysql, how can we plot specific record to a desired map using the search or rather when opening a map and upon mouserollover it displays the record. Upon clicking the displayed record, it will displays its complete details to another page. How? What are the syntax? Please give some example.
Answer:
Answer by Colanth
It’s not that simple. You can use onMouseOver to initiate an AJAX request to the server for the record for that part of the map, then use Javascript to display the results when they come back. There’s no “put this code there” solution.
Question: How can I display foreign language characters on a webpage from mysql?
I have english characters, greek, russian, chinese, etc. stored in mysql as UTF-8. When I try to query and display the text, I get ???????????????? chars and boxes. (it is stored properly in mysql and displays fine via phpmyadmin, but not on my site).
Anyone know to display these UTF-8 characters?
Answer:
Answer by bubba5
You have to use this in PHP after you make the MySQL connection: mysql_set_charset(‘utf8′,$ databaseconnection);
More at the link below…