Need idea about connect database after different time

[windforceus]

Hi ALL

I have a php website connected to mysql database and I plan to backup my database at 12pm every night. My problem what happen if someone log in to my website at that time? I don't know if there is such thing to disconnect user in php or reconnect a different database at certain. So plz help.!

ray

[jpr]

Why is it a problem if a user logs in right at the exact same time as you back up the database (which is extremely unlikely anyways).

[windforceus]

Say user already log in to the site and the site connects to database A and i need to make a backup. Then users can't log in at that time because the server wont' be able to handle their request and store information to database A( because i am making backup) . Therefore, users have to log out and my whole website database connection has to be redirect to database B. Is this possible?