• How to backup MySQL users and their privileges

    Is there a way to actually backup our MySQL users and their privileges? Would mysqldump work? Here's what I have so far: mysqldump -d -u root -p MyTable > Schema.sql Thanks so much!

    ITKE371,690 pointsBadges:
  • MySQL backup option for Windows Server

    What would be the best MySQL backup option for Windows Server? I need to only backup my data. Also, the backup needs to be done somewhere outside the the server and I would prefer a free option too. Thank you!

    ITKE371,690 pointsBadges:
  • Backup stored procedures in MySQL

    With MySQL, I've been using mysqldump to back it up daily. But how do I store stored procedures? Is it backed up with everything else?

    ITKE371,690 pointsBadges:
  • How to run a MySQL database backup during the day

    We're trying to backup a MySQL database but we need it run during day (so there is a load on the server). We can't have it impact Apache and our other databases that are running on the same server. Can we use the mysqldump command? Appreciate it

    ITKE371,690 pointsBadges:
  • Best way to backup a MySQL server

    Hi experts! In everyone's opinion, what would be the best way to back up a MySQL server? Is there a way to do it that wouldn't bring down the server? Should we just use the MySQL Administrator tools? We appreciate the help.

    ITKE371,690 pointsBadges:
  • Backup database in MySQL

    We currently have a 4 GB database that's in MySQL. What's the best way for us to back it up? We have had a few times that we almost lost all of the data. In another question, would there be a way to speed up the backup process in the event we need to recover? I appreciate the help.

    ITKE371,690 pointsBadges:
  • How to restore MySQL database Windows tool?

    Hello, I have a database already created. Now, I would like to restore a backup copy. Does the commands MySQL -<id> -p <database> < backup.sql delete the existing database and then create a new one or do I have to do the following: Delete the existing DB Create the database Restore...

    9rudolf5 pointsBadges:
  • Limitations to adding NDB cluster on MySQL

    I'm trying to implement a NDB cluster for MySQL 6. I'm trying to do it with a very large data structure (2 million databases). Are there any limitations of implementing a NDB cluster? RAM size perhaps? Appreciate the help.

    ITKE371,690 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • MYSQL 1160 error: Can someone help me out?

    I have received MySQL error 1160 'error writing communication packets'. I have a stored procedure that does this: Step 1: compares the data from two tables and insert into a tmp table. Step 2: Results from tmp table will then copied over to a table with FEDERATED engine. This Federated table is...

    LuuKjed15 pointsBadges:
  • MySQL error: File not found

    Last two days I am getting the same error in MySQL 5.1.23 - 'File' Not Found. It appeared suddenly and I really don`t know the reason of such MySQL behavior. I mean, everything worked fine until the last days. I tried to use a build-in options, such Repair database and check table. These features...

    Dryhthelm5 pointsBadges:
  • Insert list of items from table in PHP/MySQL

    I am trying to insert list of items from dev.test1 table, but I am struggling with logic ... Face following problems: - Before insert statements I would like to add "if not exists" - select content from dev.qa_postmetas - f.URL which I am getting in second query is not coming from correct row...

    spider225 pointsBadges:
  • Understanding Database instructions

    What does 'querying the current user' mean?

    ryancey5 pointsBadges:
  • Does MySQL support foreign key?

    In WAMP server when you create table there is no option for foreign key.

    arpita2345 pointsBadges:
  • Membership login with MySQL

    Hi, I'm doing a login program which will be using MySQL. I would like to how do I do that, I have done a little but I'm stuck half way can anyone help? protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { MySqlConnection conDatabase = new...

    Blue50 pointsBadges:
  • MySQL Replication I think!

    Hi, I have a local Access Database that is the management system for a business. They now want to take some feature online so customers can do some functions themselves. What I am thinking is migrate the data to MySQL and use a local install of MySQL as the backend and point the Access front end at...

    Awestrope5 pointsBadges:
  • Running different versions of MySql on same machine?

    Is it possible to run different versions of MySql on the same server machine?

    Ozzyit25 pointsBadges:
  • Migrate MySQL database to SQL 2005

    We are looking to migrate from MySQL to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

    Karl Gechlik9,860 pointsBadges:
  • MySQL capabilities

    Do you guys know where Can I find specific details for MySQL like max number of records, max number of connections, max size of database etc etc? My version is Ver 14.12 Distrib 5.0.51a.

    Musoteflirt20 pointsBadges:
  • VB.NET development environment

    I am coming out of retirement and have a couple of projects I was going to do in VB 6. After doing a little research it became clear that I needed to migrate my development environment from VB 6/SP 6 to VB.NET. My question is very basic, what do I need to start VB.NET development? I do not have any...

    GlennSwett5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.