How and where do i backup data base in vb4.2.2 ?

[chris.t]

How and where do i backup data base in vb4.2.2 ?

And is the data base the only thing I need to back up? Im a newbie here, so be gentle.. :)

Thanks for any help.

chris

[Dave]

You can do it with mysqladmin on Linux/Windows, a mod like https://vborg.vbsupport.ru/showthread.php?t=231481 or export it with something like PHPMyAdmin.

[loua_oz]

Your web hosting would almost certainly have backup utilities.
Mine (webhostinghub.com) has database backup, home directory backup and full system backup options.

Database backup is fairly a small .gz file, when database backup is initiated, you can chose to save it on your local disk and preserve it. For my site (a small one) it takes minutes to have it on my local C: disk.

It helped me restore and recover from hacks several times.

[cellarius]

Well - the size of the backup file obviously depends on what you define as fairly small and how large your database is. I wouldn't call my database backups fairly small, tbh ;)

phpMyAdmin is not a good tool to do database backups - especially not to do restores. If your hoster does not provide that functionality (and most do not), I recommend MySQLDumper:
http://www.mysqldumper.net/

Or, of course, if you have shell access, you just can do it via a command line cron.