• Is MySQL robust enough for very high traffic websites?

    Just so you have an idea of what I'm asking or looking for as far as database needs , I'm working on a classified ads website gaining a lot of traffic. The database behind it is MySQL. However, my concern is if MYSQL is fit to handle high traffic websites. For example, would a website with 12...

    itguyla5 pointsBadges:
  • Handle MySQL backups with Git

    For our MySQL backup, we came up with a pretty good idea but we're not entirely sure. To backup it up, we thought of putting the dump file into a Git repository, and the commit on each dump so we have the most recent copy / we can roll back to a previous backup. But we're not sure of the flaws...

    ITKE361,590 pointsBadges:
  • How to do MySQL backups on a budget

    Our MySQL backup strategy is to replicate our database to a second server and then run mysqldump on that server to get rid of any downtime from table locking. It's working great but the cost is huge (Over $150 per month on that second server). Anyone know of another way to do MySQL backups cheaper?...

    ITKE361,590 pointsBadges:
  • Performance issue with MySQL database backup

    My friend and I have been trying to create a regular backup for a production database (large one, in fact). The database has both InnoDB and MyISAM tables. We have been using mysqldump but it keeps taking longer and longer each time. Sometimes, the server is even unresponsive when the dump is...

    ITKE361,590 pointsBadges:
  • 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!

    ITKE361,590 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?

    ITKE361,590 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?...

    ITKE361,590 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!

    ITKE361,590 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!

    ITKE361,590 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?

    ITKE361,590 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

    ITKE361,590 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.

    ITKE361,590 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.

    ITKE361,590 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.

    ITKE361,590 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:

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