|
How do you create a database backup of a mysql database in VB.Net?
Answer Snippets (Read the full thread at stackoverflow):
mysql --host=[HOSTNAME] --user=[USER] --password=[PASSWORD] [DATABASE NAMEyou could invoke....
I would write a stored proc, since MySQL 5 the mysql command instead.
Can read each table's data and write it to a new database.
|
|
For whatever reason, the "mysql" database on my windows mysql installation has been deleted. I now have a mysql install that cannot start because the system database is missing, but I cannot find any documentation on recreating this database.
How do I...
Started by Chris on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Unfortunately, according....
Here's an sql dump from my mysql table: http://www.box.net/shared/js92gum4gh.
On Unix, you would move your existing database data directory out of the way and run mysql_install_dbReinstall MySQL.
|
|
Well, I am going to design a database structure, but I don't know where to start. Can you guys help me by answering the following questions? My database is going to store about hundreds of thousands rows/data and serving 1000 ++ users at the same time...
Started by bbtang on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You guys design a mysql database structure? Must I study normalization first? I suck at this topic are the important things in designing mysql database structure?
Plan ahead, I would seriously consider creating, what are the....
|
Ask your Facebook Friends
|
Hello there,
I'm confused when trying to fetch table rows in mysql using C++ with MySQL C API.
I can do it easily in PHP, just because C++ is a strongly-typed language so that we also need to take care of the dirty process..
This is how I done it in PHP...
Started by djzmo on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
So, your code should be something like:
mysql_query(sqlhnd, "SELECT * FROM `my_table`"); MYSQL....
In the MySQL C API, mysql_fetch_row returns a MYSQL_ROW object, which is essentially an array of values in the current row.
|
|
SQL Server to MySql conversion, i want convert the SQL Server query dump to mysql database.
I have SQL Server query dump.
Please give me a good conversion tool free of cost.
I tried with phpmyadmin import feature, its not working.
Started by itsoft3g on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Ms2my @ SourceForge - (Free) MSSQL to MySQL Converter
hi,
I found a application which is best.
|
|
I was wondering how can I select a value from a database that a user just entered it into and then add it to another mysql table all in the same script before the script is finished running.
Started by tor on
, 8 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Is "SELECT a value from MySQL database"), you can get what he just entered by:
$last_id = mysql-mysql-tutorial.html
Or also: http://lmgtfy.com?q=php%20mysql%20tutorial
In theory you perform just entered, you'll need:
mysql....
|
|
I am using MySql 5.1 Database.
I have created a Project database. (Temnplate Database)
and want to Create a copy of the same database from the Application, every time, User Creates A new Project.
How can I copy and Create a New Database of same structure...
Started by Ashok Gupta on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
To create a new copy, do a "create database new-database-name.
The -d flagDump the database with the -d option.
Ppass -d olddb | mysql -u user -ppass -Dnewdb
The new database must exist already.
|
|
I am writing a code that access a MySql database. The database is on a server that we access through our web-browser
Let's say,
URL: http://cbm.goo.com/phpMyAdmin
Username: username
Password: password
The above username and password are used to access...
Started by Yatendra Goel on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Your MySQL server is using port 3306..
Using JDBC with MySQL quick start guide
Check that your internet connection is not going through.
|
|
Does the MySQL command :
FLUSH TABLES;
flush every table in the current database, or every table on the server ?
I'm using MySQL 5.0 - the documentation is unclear, although it does mention that :
FLUSH TABLES WITH READ LOCK;
will do so for ALL databases...
Started by Richard on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I even read the source code....
I found the MySQL Internals documentation on FLUSH TABLES , but it doesn't say specifically.
Error(): No Database selected
with "flush tables" there is no mysql_error, so i think the answer, as you did.
|
|
Hi, would my presumption be correct, that any MySQL 5.0.x database is compatible with any MySQL 5.0.x system?
I ask as I am seriously considering wiping my server and starting afresh with Debian instead of RHEL5.
I have a db which is 5.0.77, and would...
Started by Mark on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Most MySQL backup guides will have you use mysqldump, which generally dumps your data out to text mysqldumps from my laptop on 5.1.37:
$ mysql --version mysql Ver 14.14 Distrib **5.1.37**, for debian-linux-gnu (i486) using EditLine....
|
