• How to restore single table my MySQL database backup

    We currently have a mysqldump that backups our MySQL database (which has a bunch of tables with roughly 440 MBs). We've been trying to restore one of the tables from the mysqldump. Would that be possible? Thanks so much!

    ITKE357,100 pointsBadges:
  • MySQL: Joining select counts from same table

    Please I want to join the statements below to get a single output Select count(*) TotalAccounts,Affiliate from realdb.tbl_logs group by affiliate Select count(*) TotalGen,Affiliate from realdb.tbl_logs where lastdate =curdate() group by affiliate Select count(*) TotalNotGen,Affiliate from...

    MaameBamfua5 pointsBadges:
  • How to backup a MySQL database daily

    As of today, I have a 20 GB MySQL database that I backup daily using mysqldump. But there's one problem with it: When I don't take down the web server, it takes forever to backup (only takes 5-10 minutes when I take it down). Would there be a better way to do a backup for this?

    ITKE357,100 pointsBadges:
  • How to backup MySQL database automatically on Windows Server

    I've been searching everywhere to find an answer to my question but still can't find anything. Would anyone happen to know if it's possible to backup a MySQL database automatically during certain times of the day to a specific server / email attachment? Should we use the Windows Task Scheduler?...

    ITKE357,100 pointsBadges:
  • 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!

    ITKE357,100 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!

    ITKE357,100 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?

    ITKE357,100 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

    ITKE357,100 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.

    ITKE357,100 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.

    ITKE357,100 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.

    ITKE357,100 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:

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.

Following