fenton Posted June 29, 2013 Share Posted June 29, 2013 Hi there, just wanted to ask if the predefined settings for exporting a PW database are recommended or if anything should be changed e.g.: thanks a lot, cheers Link to comment Share on other sites More sharing options...
Wanze Posted June 29, 2013 Share Posted June 29, 2013 Looks good to me. I never changed any of the default settings for a simple sql export Cheers 2 Link to comment Share on other sites More sharing options...
fenton Posted June 29, 2013 Author Share Posted June 29, 2013 thanks! Link to comment Share on other sites More sharing options...
kongondo Posted June 29, 2013 Share Posted June 29, 2013 I never even go to the advanced settings...The simple export works fine for me.. Link to comment Share on other sites More sharing options...
fenton Posted June 29, 2013 Author Share Posted June 29, 2013 I never even go to the advanced settings...The simple export works fine for me.. this is the regular interface for exporting in XAMPP (no option for simple settings) Link to comment Share on other sites More sharing options...
kongondo Posted June 29, 2013 Share Posted June 29, 2013 What I meant is I use the " Quick - display only the minimal options". I think you are using "Custom - display all possible options"? Below is the screen I see on XAMPP using the Quick Export... Link to comment Share on other sites More sharing options...
fenton Posted June 29, 2013 Author Share Posted June 29, 2013 hey kongondo, guess I use another version of XAMPP (http://www.apachefriends.org) v.1.7.4, since I don't have that option and my interface looks different love your avatar btw! Link to comment Share on other sites More sharing options...
kongondo Posted June 29, 2013 Share Posted June 29, 2013 I'm on XAMPP version 1.7.7. Avatar: Thx...yeah...thx to Horst for the avatar 1 Link to comment Share on other sites More sharing options...
OrganizedFellow Posted June 30, 2013 Share Posted June 30, 2013 Wouldn't it be simpler to export the database using some PHP script? I've always thought that to be a better idea. Link to comment Share on other sites More sharing options...
kongondo Posted June 30, 2013 Share Posted June 30, 2013 Why reinvent the wheel? Of course you can do that. I just prefer using phpMyAdmin for this 1 Link to comment Share on other sites More sharing options...
Wanze Posted June 30, 2013 Share Posted June 30, 2013 Wouldn't it be simpler to export the database using some PHP script? I've always thought that to be a better idea. Why simpler? When transfering a site locally to the server, I'm always using phpmyadmin. Export all data to a mysql file takes me one minute, importing is just as easy. I think it doesn't matter how you export your stuff - more important is (if there's no other backup running) to do it at all 1 Link to comment Share on other sites More sharing options...
OrganizedFellow Posted June 30, 2013 Share Posted June 30, 2013 Why simpler? Using phpmyadmin: 1. mywebsite.com 2. go to mywebsite.com/phpmyadmin and select database and click export and click GO. DONE! Using php script: 1. mywebsite.com/securebackup DONE! NOTE: I've actually been using adminer (http://www.adminer.org/) instead of phpmyadmin. Super tiny script. Fast. Easy 1 Link to comment Share on other sites More sharing options...
ryan Posted July 3, 2013 Share Posted July 3, 2013 When exporting with PHPMyAdmin, I sometimes have to uncheck the "use extended inserts" in order to get it to import somewhere else. Apparently the maximum query length can vary from server to server, and avoiding extended inserts reduces or eliminates that problem (at the expense of a slightly larger SQL file). 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now