n00bfreak

I have got the remote server working as well thanks to http://www.tonyspencer.com/2007/03/02/setup-a-subversion-server-in-4-minutes/ all good now, thanks for everyones help. now I can develop and implement much faster and better..

Ok I managed to get the SVN repo working locally, but now it still wont solve my problem, I need to sync it remotely.. how can I do that? I cannot connect from my server to my laptop, so syncing from my laptop repo on the server wont really work, I need my laptop to connect to my server and update the repo files from the laptop, to the server..

Thanks guys, for anyone who wants to have a similar setup, I found this tutorial helpful: http://linux.byexamples.com/archives/255/svn-command-line-tutorial-for-beginners-1/

I am using NetBeans IDE, noticed there is a subversion option there as well... If you don't mind can you point me to where I can read about setting that up?

I think its more like the version control systems, how do I go about implementing that on both the server and the laptop? Thanks a lot for your help Mchl

Say the flat-file has the following: test:test2 test3:test4 test5:test6 test:test2 Can I have load-data make sure that there are no exact same data in the DB before it inserts? in that example, it would insert everything except the last line One more thing, how would it know which bit to insert in which row? Thanks!

I am new to web development, I recently started freelancing online for a few clients and got some projects lined up. TLDR: I want an easy to manage my web dev projects (hosted on my laptop) and sync them with my webserver online. Now here is my situation: I have a laptop where I do my work and test it on, this laptop runs Ubuntu 10.04. I have a VPS online, which runs CentOS, it is mainly used to upload the demo work of my projects so I can show them to my clients and blow there minds away. My problem here is: The time I am wasting, and the effort in uploading and updating everything I do once I am done with it on my laptop, its pretty irritating, I have to tar everything up, upload it to the server, put it in the right place, make sure all permissions are correct, upload the MySQL database, import it to the VPS, edit the config files to match the new username and password.. etc etc.. What I really want to have: Is an easier way to do all that, I want to be able to press a button or type a command, that will automatically sync my laptop files with the right directory on my VPS. so it cant be just a simple way where it just simply uploads the files, it needs to be able to manage each project separately. I can't wait to read your comments, hopefully someone will give me a detailed solution to what I need to do, thanks!

Hello, I am trying to find the best and fastest way to insert data from a text file into a MySQL DB, currently I am using a very newbie technique: <?php function import_stuff($list) { $x = 0; $y = 0; $list = file($list); foreach($list as $line) { $y++; $line = str_replace("\n","",$line); $line = explode(":",$line); $stuff1 = $line[0]; $stuff2 = $line[1]; $q = mysql_query("SELECT `stuff1` FROM `stuff` WHERE `stuff1` = '$stuff1' and `stuff2` = '$stuff2'"); if(mysql_num_rows($q) <= 0) { if($stuff1 != NULL && $stuff2 != NULL) { $stuff2 = mysql_real_escape_string($stuff2); $q = mysql_query("INSERT INTO `stuff` (`stuff1`,`stuff2`) VALUES ('$stuff1','$stuff2')"); $x++; } } } echo "Inserted $x out of $y stuff\n"; } ?> This would take a lot of time processing a file with 10,000 lines for example... If you have any ideas of a better way, please guide me thro it, it needs to check if the information is in the DB before it inserts it, meaning all the information in DB needs to be unique. Thanks!