what is the best way to backup mysql database? using a mysql existing tool or technique?

The database has million of records, and will need to be backed up every data entry from the user. Answer For small databases I’m personally use phpMyAdmin. For bigger databases (SQL dump is, let’s say, more than 5MB) I prefer backing up from command line using standard MySQL tool mysqldump: mysqldump -h localhost -u username … Read more

Bulk create thousands of mysql database giving errors [closed]

Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 8 years ago. Improve this question I need to create thousands of database such like below: CREATE DATABASE adr0711 CHARACTER SET utf8 COLLATE utf8_bin; CREATE DATABASE adr0712 CHARACTER SET … Read more

How to acquire a unique IP address [closed]

Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 8 years ago. Improve this question How do I assign a unique IP address for my remote server? I am using windows 7 Operating System. Any other security configurations … Read more

Database Backup using DOS commands or any other useful commands [closed]

Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 7 years ago. Improve this question I am planning to backup my database files from network drive to one other. Here is my requirement: All database should be backed … Read more

Ticketing server database security [closed]

Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 8 years ago. Improve this question I want to setup a ticketing system which will show the seats available instantly. However, … Read more

Database File In Drop Box Shared Folder

Can a software database file be saved and kept in a shared folder like drop box and be accessed and used (whether simultaneously or not) from more than one computers? A quickbooks database file is an example. Can it be centrally located on a dropbox folder and be accessed by a computer from another location … Read more

What should I choose a database. I hate to relational databases [closed]

It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 12 years ago. What should I choose a database, I hate … Read more

how to connect my server to internet [closed]

It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 9 years ago. We have a project which very resource consuming … Read more

Is RAM size related to SQL performance? [closed]

Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 8 years ago. Improve this question I have some simple code that generates 3 millions insert queries. I have two VPSes, … Read more

Can’t login into phpmyadmin but password is correct

I’m trying to login into my phpmyadmin but it keeps redirecting me back to the login page. My username password should still be correct becuase my website is still functioning and I can even login to my mysql using putty. I was getting “Cant create/write to file ‘/tmp/XXXXXXX’ Errcode28” error messsage which meant my space … Read more